Show TOC

Restoring a Database from an Archive Backup (Interactive SQL)Locate this document in the navigation structure

Use Interactive SQL to restore a database from an archive backup.

Prerequisites

You do 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, specify the encryption key for the database when restoring it.

Procedure

  1. Start a personal database server:
    dbeng16 -n <server-name>
  2. Start Interactive SQL and connect to the utility database. Complete the following fields:
    1. In the User ID field, enter DBA.
    2. In the Password field, enter sql.
    3. In the Database Name field, enter utility_db.
  3. Click OK.
  4. Execute a 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.

Results

The database is restored.

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';

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. The encryption key is specified for the database.

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