Performing Sybase SQL Anywhere Image Backups

Applies to: Sybase SQL Anywhere and SAP Advantage Database

Use the dbbackup utility to perform image backups. The dbbackup utility creates a backup copy of all the files for a single database. The image backup created by the dbbackup utility consists of a separate file for each file that is backed up.

Use the dbunload utility to obtain the SQL dump of the database, that you can use to rebuild the database. Use the file system agent to back up the obtained reload file and the associated dumped data.

You must perform FULL backups of the subclient created for SQL Anywhere image data backups. You can perform them manually or schedule them at periodic intervals.

You must perform frequent Incremental backups of the subclient created for SQL Anywhere image log backups as the system will pick up only the recent transaction log copies generated in the log backup directory. You can perform them manually or schedule them at periodic intervals.

Procedure

Performing a SQL Anywhere Data Backup

1. From the CommCell Browser, expand Client Computers > client > File System > backup_set.

2. Right-click the SQL Anywhere subclient, and then click Backup.

3. On the Backup Options for Subclient dialog box, select the backup type and job initiation:

   1. In the Backup Type section, select the Full option.

   2. In the Job Initiation section, choose to run the backup now or schedule it.

      Note

      If you selected Schedule, set up the schedule.

      For information about configuring a backup schedule, see Schedule backups.

4. Click OK to close the Backup Options dialog box.

Performing an SQL Anywhere Log Backup

1. From the CommCell Browser, expand Client Computers > client > File System > backup_set.

2. Right-click the SQL Anywhere subclient, and then click Backup.

3. On the Backup Options for Subclient dialog box, select the backup type and job initiation:

   1. In the Backup Type section, select the Full option.

   2. In the Job Initiation section, choose to run the backup now or schedule it.

      Note

      If you selected Schedule, set up the schedule.

      For information about configuring a backup schedule, see Schedule backups.

4. Click OK to close the Backup Options dialog box.