Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Maintaining Your Database » Backup and data recovery » Making a client-side backup

 

Make 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 in case 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 dbbackup utility 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 carry out a live backup of the transaction log by using the dbbackup utility with the -l option.

To 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. Periodically, perform a full backup to the secondary computer.

    For example:

    dbbackup -c "UID=DBA;PWD=sql;ENG=testsrv;DBN=test;LINKS=tcpip" c:\backup
  3. Run a live backup of the transaction log to the secondary computer.

    dbbackup -l path\filename.log -c "connection-string"
  4. Regularly run the dbbackup utility from the secondary computer.

    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