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 SQL Remote Message Agent (dbremote) with the -u option. When the SQL Remote 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.
Use a transaction log mirror Using a transaction log mirror protects against media failure on the transaction log device.
Do not run SQL Remote Message Agent (dbremote) with the -x option on the consolidated database Never run the SQL Remote 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.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|