336
ZENworks 10 Configuration Management System Administration Reference
n
ov
do
cx (e
n)
16
Ap
ril 20
10
1d
Click the
Database
tab, then specify the name of database service that is currently
running.
1e
Click
OK
.
2
Change the database backup schedule and the backup location as desired.
You can use the same SQL query to change the database backup schedule and the backup
location. You can change the backup schedule and the location at the same time or at a different
time.
ALTER EVENT
name_of_the_existing_backup_schedule_event_containing_the_database_backup
_schedule_or_location_that_you_want_to_change
SCHEDULE
new_database_backup_schedule
or
existing_backup_schedule
HANDLER
BEGIN
BACKUP DATABASE DIRECTORY
‘
complete_path_of_the_existing_database_backup_location
or
complete_path_of new_database_backup_location
’
TRANSACTION LOG TRUNCATE
END;
If you want to back up the database to a directory on Windows, you must use \\ (double
backslash) as the delimiter while specifying the database backup directory path
For example, assume that you have database backup event,
zendbbackup
, that locally backs up
the database to
c:\dbackup
at 1:00 a.m. every day. If you want to change the database backup
schedule or location, review the following:
If you want to back up the database at 11:00 p.m. on Monday, Wednesday, and Friday of
every week, change the database backup schedule in the
zendbbackup
event by executing
the following query in the DBISQL utility:
ALTER EVENT zendbbackup
SCHEDULE
'11:00 PM' ON (‘Monday’, ‘Wednesday’, ‘Friday’)
HANDLER
BEGIN
BACKUP DATABASE DIRECTORY ‘c:\\dbbackup’
TRANSACTION LOG TRUNCATE
END;
If you want to back up the database to a new location, such as
e:\zendb\dbbackup
,
change the database backup location in the
zendbbackup
event by executing the
following query in the DBISQL utility:
ALTER EVENT zendbbackup
SCHEDULE
'1:00 AM' EVERY 24 HOURS
HANDLER
BEGIN
BACKUP DATABASE DIRECTORY ‘e:\\zendb\\dbbackup’
