Restoring from an archive backup

 Restore a database from an archive backup (Sybase Central)

This procedure assumes that you do not have any incremental backups of the transaction log that you need to apply as part of the recovery process. For information about recovering a database when you have backed up multiple copies of the transaction log, see Database recovery with multiple transaction logs.

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.

  1. Start a personal database server.

    For example, the following command starts a database server named restore:

    dbeng12 -n restore

  2. Start Sybase Central and connect to the utility database. Complete the following fields:

    • User ID   Type DBA.

    • Password   Type sql.

    • Database Name   Type utility_db.

  3. Click OK.

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

  5. Follow the instructions in the wizard.

 Restore a database from an archive backup (Interactive SQL)

  1. Start a personal database server.

    For example, the following command starts a database server named restore:

    dbeng12 -n restore

  2. Start Interactive SQL and connect to the utility database. Complete the following fields:

    • User ID   Type DBA.

    • Password   Type sql.

    • Database Name   Type utility_db.

  3. Click OK.

  4. Execute the RESTORE DATABASE statement, specifying the archive root.

    At this time, you can choose to restore an archived database to its original location (the default), or to a different computer with different device names using the RENAME clause. See RESTORE DATABASE statement.

 See also
 Example
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1