> CommCell Console > Backup and Restore Agents > Databases > Sybase > Sybase Configurations > Configuring Sybase SQL Anywhere > Configuring Image Backup

Creating a Subclient for Log Backup

Use the following steps to create a subclient for log backups:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | File System iDataAgent.

  2. Right-click the <BackupSet>, point to All Tasks, and then click New Subclient.

    sql_anywhere_config

  3. In the Subclient Name box, type the subclient name.

    sql_any_config_log01

  4. Click the Storage Device tab.

  5. In the Storage Policy box, select the storage policy.

  6. Click the Pre/Post Process tab.

  7. Click Browse to locate the log directory path and add the script for log backup.

    The script should contain the dbbackup command. This command should include the log backup directory path to backup the transaction log files as a pre-scan process.

    sql_any_config_log03

  8. Click the Content tab.

  9. Click Add Paths.

  10. Add the local path for log backups and click OK.

    sql_any_config_log02

  11. Click OK to create a subclient for log backup. Perform Incremental backups for this subclient at periodic intervals as the system will pick up only the recent transaction log copies generated in the log backup directory.

The log backup script for UNIX and Windows based file systems will be as follows:

dbbackup  -y -o log output file  -c "connect string" -r -t -n log-backup-directory

where

-t : Backup transaction log.

-r : Rename and restart the transaction log.

-n : Rename local backup of transaction log to match server.

-x : Delete/truncate the transaction log

-y : Creates the backup directory or replaces a previous backup file in the directory without confirmation. If you want to be prompted when an attempt is made to overwrite an existing file, do not specify -s or -y.

Example (UNIX)

dbbackup  -y -o /temp/SqlAnywhereBackup.log -c "eng=demo11;dbn=mydb;uid=dba;pwd=sql;LINKS=ALL" -r -t -n /databackup/logBackup

Example (Windows)

dbbackup  -y -o c:\temp\SqlAnywhereBackup.log -c "eng=demo11;dbn=mydb;uid=dba;pwd=sql;LINKS=ALL" -r -t -n d:\logBackup

Example (UNIX)

dbbackup  -y -o /temp/SqlAnywhereBackup.log -c "eng=demo11;dbn=mydb;uid=dba;pwd=sql;LINKS=ALL" /dataBackup/full

Example (Windows)

dbbackup -y -o c:\temp\SqlAnywhereBackup.log -c "eng=demo11;dbn=mydb;uid=dba;pwd=sql;LINKS=ALL" d:\dataBackup
×

Loading...