External Database Maintenance
317
n
ov
do
cx (e
n)
16
Ap
ril 20
10
BACKUP DATABASE DIRECTORY
‘\\\\
IP_address_of_remote_machine
\
\backup_directory\\custom_directory
’ TRANSACTION LOG TRUNCATE
In the query,
\\\\
IP_address_of_the_remote_machine
\
\backup_directory
\\ is
the shared network location on the remote machine and
custom_directory_name
is a
name that you specify for a directory to be newly created and into which the database files
are to be backed up.
For example, execute the following query to back up the database to the
dbbackup
directory:
BACKUP DATABASE DIRECTORY
‘\\\\
shared_network_location_on_remote_machine
\\dbbackup’ TRANSACTION
LOG TRUNCATE
You must manually archive the complete path of the database backup location that you
specify in the query because you need to specify it if you want to change the database
backup location at a later time.
4b
Click
Execute SQL Statement(s)
.
5
To schedule the backup to run at a specific time every day or on specific days of a month:
1. Execute the following query by specifying it in the
SQL Statements
section:
CREATE EVENT
backup_schedule_name
SCHEDULE
START TIME
specify_the_schedule
HANDLER
BEGIN
BACKUP DATABASE DIRECTORY
‘\\\\
IP_address_of_remote_machine
\
\backup_directory\\custom_directory
’
TRANSACTION LOG TRUNCATE
END;
In the query,
\\\\
IP_address_of_the_remote_machine
\
\backup_directory
\\ is
the shared network location on the remote machine and
custom_directory_name
is a
name that you specify for a directory to be newly created and into which the database files
are to be backed up.
While creating a database backup event, use the following guidelines:
The backup schedule name must be unique.
You must manually archive the backup schedule that you specify in the query
because you need to specify it if you want to change the database schedule at a later
time.
2. Click
Execute SQL Statement(s)
.
Examples:
To back up the database at a 1:00 a.m. every day to the
dbbackup
directory on Windows,
execute the following query:
CREATE EVENT ZENDBbackup
SCHEDULE
START TIME '1:00 AM' EVERY 24 HOURS
Содержание ZENWORKS 10 CONFIGURATION MANAGEMENT SP3 - NETWORK DISCOVERY DATABASE STRUCTURE
Страница 4: ...4 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 18: ...18 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 26: ...26 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 60: ...60 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 64: ...64 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 70: ...70 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 78: ...78 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 98: ...98 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 118: ...118 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 138: ...138 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 140: ...140 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 142: ...142 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 144: ...144 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 162: ...162 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 164: ...164 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 168: ...168 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 170: ...170 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 190: ...190 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 212: ...212 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 214: ...214 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 224: ...224 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 234: ...234 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 236: ...236 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 242: ...242 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 250: ...250 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 256: ...256 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 282: ...282 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 284: ...284 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 290: ...290 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 292: ...292 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 330: ...330 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 338: ...338 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 340: ...340 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 348: ...348 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 360: ...360 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 362: ...362 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 368: ...368 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...
Страница 374: ...374 ZENworks 10 Configuration Management System Administration Reference novdocx en 16 April 2010...