> CommCell Console > Backup and Restore Agents > Databases > Sybase > Sybase Restores > Restoring SQL Anywhere Backups

Restoring Image Backups

Use the following steps to restore an image data backup:

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

  2. Right-click the Subclient created for SQL Anywhere data backups in the right pane and then click Browse and Restore.

    image_data_restore

  3. Click View Content.

  4. Select the database files that you want to restore and click Recover All Selected.

  5. Stop the database and rename the database files.

  6. In the Restore Options dialog box, select the Destination client from the drop down list.

  7. Type the destination path or click Browse to select the destination path to restore the selected database files.

    image_data_restore01

  8. From the CommCell Browser, navigate to Client Computers | <Client> | File System | <Backup Set>.

  9. Right-click the Subclient created for SQL Anywhere log backups in the right pane and then click Browse and Restore.

    image_log_restore

  10. Click View Content.

  11. Select the log files that you want to restore and click Recover All Selected.

    image_log_restore01

  12. Click Advanced.

  13. Click Pre/Post tab.

  14. Click Browse to locate the recoverDBScript path and add the script for recovering the database and transaction log files.

    The script should contain the dbeng as a post recovery command. This command should include the database file and transaction log files location.

    image_adv_restore

  15. Click OK.

The recoverDBScript dbeng for UNIX and Windows based file systems will be as follows:

dbeng11 -n Server-Name Database-File -ad Transaction-Log-Files-Location.

where

-ad : specifies the location of the transaction log files. The database server determines the correct order for applying the transaction logs to the backup copy of the database based on the log offsets.

Example (UNIX):

dbeng11 "/Sybase Anywhere/mydb/mydb.db" -ad /databackup/LogBackup$

Example (Windows):

dbeng11 "d:\Sybase Anywhere\mydb\mydb.db" -ad d:\LogBackup

Note

Use dbspawn command with dbeng utility to start the database server in the background.

Example:

dbspawn dbeng11 "/Sybase Anywhere/mydb/mydb.db" -ad /temp1/LogBackup(UNIX)
dbspawn dbeng11 "d:\Sybase Anywhere\mydb\mydb.db" -ad d:\LogBackup(Windows)

Note

×

Loading...