20.2 Changing the Backup Location and Schedule of the Embedded Sybase Database Subsequent to the Initial Backup

20.2.1 Changing the Backup Location of the Embedded Sybase SQL Anywhere Database Subsequent to the Initial Backup

To change the backup location of the embedded Sybase SQL Anywhere database subsequent to its initial backup:

  1. Delete the existing database backup schedule by executing the following command at the Primary Server command prompt:

    zman db current_database_backup_location DropSchedule.sql

    Dropschedule.sql is located by default in the ZENworks_Installation_directory:\Novell\Zenworks\share\zman\samples\database 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 to a new location:

    zman database-backup complete_path_of_the_new_database_backup_directory complete_path_of_the_database_backup_schedule_file -d SQL_function_call

    For example, to back up the database to the c:\dbbackup\newdbbackups directory on a Windows server according to the database backup schedule specified in the c:\backUpschedule.sql, enter the following command:

    zman database-backup c:\dbbackup\newdbbackups c:\backUpSchedule.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 11 SP4 Command Line Utilities Reference.

20.2.2 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\database 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 11 SP4 Command Line Utilities Reference.