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.
You must have the BACKUP DATABASE and VALIDATE ANY OBJECT system privileges.
Context and remarks
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.
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.
Connect to the database from the secondary computer.
Validate the database.
From the secondary computer, perform a full backup to the secondary computer:
dbbackup -c "connection-string" path-on-secondary-computer\filename
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"
From the secondary computer, regularly run a full backup of the online database.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|