Customized handling of data server errors

You can customize how Replication Server handles data server errors. If you want the DSI to continue applying updates even when a data server error is encountered, you can change the error action from stop_replication to log or retry_log. To make this change, use the assign action command at the Replication Server where the error class was created. All databases using the error class are affected. If the primary database for a class is at a different site, then you may need to wait until the new error action is replicated to the local site.

To limit the change to one database, create a new error class with the create error class command. Specify the desired error actions for the class, then change the connection to the database to use the new error class.

If you want to examine the commands in the transaction that caused the connection to be suspended, use the sysadmin log_first_tran command. This command writes the first transaction into the exceptions log without skipping it.