Recovering From the Failure of a Subscriber Database

You can recover a subscriber database if it fails.

To recover, either:

  • Connect to the failed subscriber. This triggers recovery from the local transaction logs. Start the replication agent and let the subscriber catch up.

  • Duplicate the subscriber from the standby database.

If the standby database is down or in recovery, then duplicate the subscriber from the active database.

After the subscriber database has been recovered, then set up the replication agent policy and start the replication agent. See Starting and Stopping the Replication Agents.