Novell ZENWORKS 10 CONFIGURATION MANAGEMENT SP3 - NETWORK DISCOVERY DATABASE STRUCTURE, System Administration Manual

Page: 337 / 374

Database Best Practices and Tips 337
n
ov
do
cx (e
n)
16
Ap
ril 20
10
TRANSACTION LOG TRUNCATE
END;
Š
If you want to back up the database at 2:00 a.m. on the first, second, and third day on the
month to a new location,
e:\zendb\dbbackup
, change the database backup schedule and
location in the
zendbbackup
event by executing the following query in the DBISQL
utility:
ALTER EVENT zendbbackup
SCHEDULE
‘2:00 AM' EVERY 24 HOURS ON (1,2,3)
HANDLER
BEGIN
BACKUP DATABASE DIRECTORY ‘e:\\zendb\\dbbackup’
TRANSACTION LOG TRUNCATE
END;