External Database Maintenance
315
n
ov
do
cx (e
n)
16
Ap
ril 20
10
Examples:
To back up the database at a 1:00 a.m. every day to the
/var/
directory on Linux, execute
the following query:
CREATE EVENT ZENDBbackup
SCHEDULE
START TIME '1:00 AM' EVERY 24 HOURS
HANDLER
BEGIN
BACKUP DATABASE DIRECTORY ‘/var/’
TRANSACTION LOG TRUNCATE
END;
To back up the database at a 1:00 a.m. on the first, second, third, and fourth day of the
month to the
c:\dbbackup
directory on Windows, execute the following query:
CREATE EVENT ZENDBbackup
SCHEDULE
START TIME '1:00 AM' EVERY 24 HOURS ON (1,2,3,4)
HANDLER
BEGIN
BACKUP DATABASE DIRECTORY ‘c:\\dbbackup’
TRANSACTION LOG TRUNCATE
END;
To back up the database to the
/var/
day_of_the_week
directory on Linux, execute the
following query:
CREATE EVENT ZENDBbackup
SCHEDULE
START TIME '1:00 AM' EVERY 24 HOURS
HANDLER
BEGIN
DECLARE backupDir varchar(256);
DECLARE backup_stmt varchar(512);
SET backupDir = DAYNAME(now());
SET backup_stmt = 'BACKUP DATABASE DIRECTORY '|| '''/var//' ||
backupDir || ''''|| ' TRANSACTION LOG TRUNCATE';
EXECUTE IMMEDIATE backup_stmt;
END;
According to the backup schedule, the
zenworks_
zone_name
.db
database file and the
zenworks_
zone_name
.log
transaction log file are created in the database backup directory.
If you want to change the database backup location or the backup schedule at a later time, see
Section 36.2.2, “Changing the Backup Schedule and Location of the External Sybase Database
Subsequent to the Initial Backup,” on page 335
.
Содержание 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...