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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database maintenance » Backup and data recovery » Database recovery

 

Restoring a database from an archive backup (Sybase Central)

Use Sybase Central to restore a database from an archive backup.

Prerequisites

You must not have any incremental backups of the transaction log that need to be applied as part of the recovery process.

If you created the backup of a strongly-encrypted database with free page elimination turned on, you must specify the encryption key for the database when restoring it.

 Task
  1. Run the following command to start a personal database server:

    dbeng16 -n server-name
  2. Start Sybase Central and connect to the utility database. Complete the following fields in the Connect window:

    1. In the User ID field, type DBA.

    2. In the Password field, type sql.

    3. In the Database Name field, type utility_db.

  3. Click OK.

  4. Click Tools » SQL Anywhere 16 » Restore Database.

  5. Follow the instructions in the wizard.

Results

The database is restored.

 See also