Database Best Practices and Tips
335
n
ov
do
cx (e
n)
16
Ap
ril 20
10
Changing the Backup Schedule of the Embedded Sybase SQL Anywhere Database
Subsequent to the Initial Backup
To change the backup schedule of the embedded Sybase SQL Anywhere database subsequent to its
initial backup:
1
Create a schedule file with the Alter Event content:
ALTER EVENT
backup_schedule_name
SCHEDULE
START TIME
specify_the_schedule
For example, you could use the
Alterschedule.sql
file to back up the database at a 11:00
p.m. on Monday, Tuesday, and Wednesday of every week as follows:
ALTER EVENT ZENDBBackup
SCHEDULE
START TIME '11:00 PM'
ON ('Monday', 'Tuesday', 'Wednesday')
A sample
Alterschedule.sql
file is available in the
ZENworks_Installation_directory:\Novell\Zenworks\share\zman\samples\datab
ase
directory on a Windows server, and in the
/opt/novell/zenworks/share/zman/
samples/database
directory on a Linux server.
2
Enter the following command to back up the database according to the new schedule:
zman database-backup
complete_path_of_the_database_backup_directory
complete_path_of_the_modified_database_backup_schedule_file
-d
SQL_function_call
For example, to back up the database to the
c:\dbbackup\
directory on a Windows server
according to the database backup schedule specified in the
c:\AlterSchedule.sql
, enter the
following command:
zman database-backup c:\dbbackup\ c:\AlterSchedule.sql -d
SQL_function_call
For more information about this command, view the zman man page (man zman) on the device,
or see
zman(1)
in the
ZENworks 10 Configuration Management Command Line Utilities
Reference
.
36.2.2 Changing the Backup Schedule and Location of the
External Sybase Database Subsequent to the Initial Backup
To change the backup location and the backup schedule of the external Sybase database subsequent
to its initial backup, perform the following tasks on the device that has the external Sybase database
installed and running:
1
Launch the DBISQL utility:
1a
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.
1b
Enter the
dbisql
command.
1c
In the
Identification
tab, specify the database credentials.
