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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Maintaining Your Database » Backup and data recovery » Backup and recovery tasks

 

Restoring an archive backup

If you use an archive backup (typically to tape), you use the RESTORE statement to recover your data.

For more information about making archive backups, see Backing up a database directly to tape.

To restore a database from an archive backup (Sybase Central)

  1. Connect to the database as a user with DBA authority.

  2. From the Tools menu, choose SQL Anywhere 11 » Restore Database.

  3. Follow the instructions in the Restore Database Wizard.

To restore a database from an archive backup (Interactive SQL)

  1. Start a personal database server. Use a command such as the following, which starts a server named restore:

    dbeng11 -n restore
  2. Start Interactive SQL. On the Identification tab of the Connect window, enter a user ID of DBA and a password of sql. Leave all other fields on this tab blank.

  3. Click the Database tab and enter a database name of utility_db. Leave all other fields on this tab blank.

  4. Click OK to connect.

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

Example

The following statement restores a database from a tape archive to the database file c:\newdb\newdb.db.

RESTORE DATABASE 'c:\\newdb\\newdb.db'
FROM '\\\\.\\tape0';

The following statement restores a database from an archive backup in file c:\backup\archive.1 to the database file c:\newdb\newdb.db. The transaction log name and location are specified in the database.

RESTORE DATABASE 'c:\\newdb\\newdb.db'
FROM 'c:\\backup\\archive';

For more information, see RESTORE DATABASE statement.