 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Replication / January 2007Transactional SQL Restore question
When recovering the subscriber in transactional replication (sql 2000) is the subscriber database restored from the publisher (essentially setting it up all over) or from the backup of the subscriber?> Thanks. -- Try to restore from the subscriber backup. Provided the retention period hasn't been exceeded and you have anonymous subscribers, then you won't lose any transactions. Otherwise, you could restore from the publisher and do a nosync initialization as you are on SQL 2000 or just initialize as per normal. Cheers, Paul Ibison SQL Server MVP, www.replicationanswers.com . So help me understand why this works. I had thought that since the transaction log is used to hold the replicated information being pushed to the subscribers, anything other than a very fast recovery on the subscribers would require a full restore from the publisher. It sounds like this is wrong. > Try to restore from the subscriber backup. Provided the retention period > hasn't been exceeded and you have anonymous subscribers, then you won't lose [quoted text clipped - 3 lines] > Cheers, > Paul Ibison SQL Server MVP, www.replicationanswers.com . The subscriber holds a copy of the xact number - the last transaction read from the log and applied to the subscriber. Restoring an older backup on the subscriber will effectively make the xact number go back in time. However, perhaps the xact number no longer exists in the MSrepl_commands table and then we have a problem. So, how long are these transactions kept in the distribution database? As long as the retention perios for anonymous subscribers, or if not anonymous enabled, then until all subscribers have read them or the retention period is reached - the lesser of these 2 times. Cheers, Paul Ibison SQL Server MVP, www.replicationanswers.com . |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.