Making a live backup

You can use a live backup to provide a redundant copy of the transaction log. This copy can be used to restart a secondary system if the primary system running the database server becomes unusable. 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.

You should run the Backup utility (dbbackup) from the secondary computer. If the primary computer becomes unusable, you can restart your database using the secondary computer. The database file and the transaction log hold the information needed to restart.

You perform a live backup of the transaction log by using the dbbackup utility with the -l option.

 Make a live backup (dbbackup utility)

  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 as a user with REMOTE DBA or BACKUP authority.

  3. From the secondary computer, perform a full backup to the secondary computer.

    For example:

    dbbackup -c "UID=DBA;PWD=sql;HOST=myhost;Server=testsrv;DBN=test" c:\path-on-secondary-computer\backup

  4. 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"

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

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

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1