Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - Database Administration » Maintaining your database » Backup and data recovery » Making a server-side backup » Using Sybase Central to make a server-side backup


Use the Create Backup Images Wizard

The Create Backup Images Wizard creates a copy of each database file. To recover, copy all the files back in place on the database server computer.

This procedure describes the simplest kind of backup, which leaves the transaction log untouched and allows you to continue using the existing transaction log.

 ♦  To make a backup (Sybase Central Create Backup Images Wizard)
  1. Connect to the database as a user with BACKUP or REMOTE DBA authority.

  2. Right-click the database and choose Create Backup Images.

  3. Click Next.

  4. In the Which Database Do You Want To Back Up list, select the database and click Next.

  5. In the Save The Backup Images In The Following Directory field, type the name of a directory to save the backup copies.

  6. Select an option in the Which Files Do You Want To Back Up list and click Next.

  7. In the What Do You Want To Do With The Transaction Log list, click Continue To Use The Same Transaction Log.

  8. Click Next.

  9. Click Finish.

  10. Click Close.


You can also access the Create Backup Images Database Wizard from Sybase Central by using the following methods:

  • Selecting a database, and choosing File » Create Backup Images.

  • Choose Tools » SQL Anywhere 12 » Create Backup Images.

 See also