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

SQL Anywhere 11.0.1 » 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.

To make a backup, continuing to use the original transaction log (Sybase Central)
  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.

Tip

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 11 » Create Backup Images.

See also