Replication Recovery -- sql server replication

georgeg
7/14/2006 11:06:02 AM

I have created a transactional Replication from Publisher A To Subscriber B.
Then I Created B as a publisher to subscriber C. The three databses are in
sync. I am doing full and Transactional Backups on all these databases.

If Database C Fails and the replication from B to C fails. How can I recover
C without losing any data in C. Database C is considered to be historical,
that is it will contain data from B and more data is inserted from other
INSERT scripts. So we cannot afford to lose the data in C. CAn I restore C
and there is a way to recreate C as a subscriber to B again.

Thanks,
--
George Gopie

Hilary Cotter
7/17/2006 6:28:28 PM

Set the transaction retention period to 1 day in your distribution database
on B. Then restore to the latest point in time you can with the transaction
log restores. The distribution agent on B will back missing transactions on
C.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

sql server replication : Replication Recovery