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

Page: 320 / 374

320 ZENworks 10 Configuration Management System Administration Reference
n
ov
do
cx (e
n)
16
Ap
ril 20
10
4 Launch the DBISQL utility on the local machine:
4a At the command prompt, go to the
%ZENWORKS_HOME%\sybase\ASA\win32
directory on
Windows or to the
/opt/novell/zenworks/share/sybase/bin32s
directory on
Linux.
4b Enter the
dbisql
command.
4c In the Identification tab, specify the database credentials.
4d Click the Database tab, then specify the name of database service that is currently
running.
4e Click OK .
5 Decide whether you want to immediately back up the external Sybase database or to schedule
the backup to run at a specific time. To back up the database immediately, continue with this
step. To schedule the backup to run at a specific time, skip to
Step 5 .
5a To immediately back up the external Sybase database to the network location on the
remote machine, specify the following query in the
SQL Statements section:
BACKUP DATABASE DIRECTORY
‘
complete_path_of_the_backup_directory_on_database_server ’ TRANSACTION
LOG TRUNCATE
For example, execute the following query to back up the database to the
/root/
zenworks_dbbackup
directory:
BACKUP DATABASE DIRECTORY ‘/root/zenworks_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.
5b Click Execute SQL Statement(s) .
6 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;
While creating a database backup event, use the following guidelines:
Š
The backup schedule name that you specify 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) .