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

Page: 314 / 374

314 ZENworks 10 Configuration Management System Administration Reference
n
ov
do
cx (e
n)
16
Ap
ril 20
10
2 Decide whether you want to immediately back up the external Sybase database or to schedule
the backup to run at a specific time. To immediately back up the database, continue with
Step 2a . To schedule the backup to run at a specific time, skip to Step 3 .
2a To immediately back up the embedded Sybase SQL Anywhere database to a directory on
the database server, specify the following query in the
SQL Statements section:
BACKUP DATABASE DIRECTORY
‘
complete_path_of_the_backup_directory_on_database_server ’ TRANSACTION
LOG TRUNCATE
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.
Examples:
Š
On Windows: To back up the database to the
c:\dbbackup
directory, execute the
following query:
BACKUP DATABASE DIRECTORY ‘c:\\dbbackup’ TRANSACTION LOG TRUNCATE
Š
On Linux: To back up the database to the
/root/dbBackup
directory, execute the
following query:
BACKUP DATABASE DIRECTORY ‘/root/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 when you want to change the database
backup location at a later time.
2b Click Execute SQL Statement(s) .
3 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
‘
complete_path_of_the_backup_directory_on_database_server ’
TRANSACTION LOG TRUNCATE
END;
2. Click Execute SQL Statement(s) .
While creating a database backup event, use the following guidelines:
Š The backup schedule name must be unique.
Š
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,
c:\\dbbackup
.
Š
You must manually archive the backup schedule that you specify in the query
because you need to specify it when you want to change the database schedule at a
later time.