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

 

Restarting a database from a live backup

Restart a database from a live backup made to a separate computer from the primary computer that is running your production database.

Prerequisites

You must have SQL Anywhere installed on the secondary computer.

You must have the BACKUP DATABASE system privilege.

 Task
  1. Copy the full backup transaction log file and the live backup transaction log to a directory where they can be applied to the backup copy of the database file.

  2. Rename or delete the current transaction log file whose name matches the expected transaction log file name, if one exists.

  3. Start the database server with the -ad option to apply the transaction logs in the directory created in step 1 and bring the database up to date:

    dbeng16 "database-name.db" -ad directory-name

    The database server shuts down automatically once the transaction log is applied.

  4. Start the database server in the normal way, allowing user access. Any new activity is written to a new transaction log.

  5. Run a live backup of the transaction log to the secondary computer.

    dbbackup -l path\filename.log -c "connection-string"

Results

The database is restarted.

 See also