SQLTeam.com | Weblogs | Forums

Restoring replicated database

  • I have 2 SQL servers replicating data 2 way, If there is a problem with server I restore a backup and rebuild the replication, but this makes data inconsistent as the new entered records in the other server during the down time will not be sent.
  • I need to be able to restore the backup so that the replication should continue with the last point the stopped.
  • Is that possible? please help.