To protect your SQL Remote replication system against media failure:
Replicate only backed-up transactions Send messages that contain only backed-up transactions. By sending only backed-up transactions, the replication system is protected against media failure on the transaction log. You can accomplish this by:
Running the Message Agent (dbremote) with the -u option. When the Message Agent (dbremote) is run with the -u option, only committed transactions that have been backed up are packaged into messages to be sent.
The -u option provides additional protection against total site failure, if backups are carried out to another site. See Message Agent (dbremote).
Use a transaction log mirror Using a transaction log mirror protects against media failure on the transaction log device. See Transaction log mirrors.
Do not run Message Agent (dbremote) with the -x option on the consolidated database Never run the Message Agent (dbremote) with the -x option against a database that is being backed up. The -x option maintains the transaction logs for replication, not for backup or recovery. To back up your consolidated database, see Back up the consolidated database.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |