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 » Client-side backups

 

Creating a live backup

Create a live backup of the transaction log by using the dbbackup utility with the -l option. A live backup provides a redundant copy of the transaction log, and can be used to restart a secondary system if the primary system running the database server becomes unusable.

Prérequis

You must have the BACKUP DATABASE and VALIDATE ANY OBJECT system privileges.

Contexte et remarques

A live backup runs continuously, terminating only if the server shuts down. If a system failure occurs, the backed up transaction log can be used for a rapid restart of the system. However, depending on the load that the server is processing, the live backup may lag behind and may not contain all committed transactions.

 Task

  1. Set up a secondary computer from which you can run the database if the online computer fails. Ensure that you have SQL Anywhere installed on the secondary computer.

  2. Connect to the database from the secondary computer.

  3. Validate the database.

  4. From the secondary computer, perform a full backup to the secondary computer:

    dbbackup -c "connection-string" path-on-secondary-computer\filename

  5. From the secondary computer, run a live backup of the transaction log to the secondary computer.

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

  6. From the secondary computer, regularly run a full backup of the online database.

Résultat

If the primary computer becomes unusable, the database can be restarted using the live backup on the secondary computer. The database file and the transaction log hold the required information for a restart.

 See also
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0