August 17, 2005 at 12:43 pm
Hi all,
I am planning to implement merge replication in my environment. we are going to have about 4 servers connected for data pull and 1 for distribution. My question is: How can I make the distribution database fail safe?
So for example if one of the replicated database goes down. i dont mind. i can point my server to look at another replicated database and I am up and running. But what if distribution database goes down? what do I do to prevent this? I dont want any of my replicated servers to be out of sync at anytime due to business requirement.
Any help or suggestions would be appriciated.
Thank you all.
Aziz Vahora
Lead DBA. http://www.cafepress.com/shop/military?tid=&bid=53&pid=1697877&aid=52
August 17, 2005 at 3:03 pm
You need to have a look at Alternate synchronization partners
* Noel
August 18, 2005 at 5:03 am
Alt sync partners provide an alternate server to sync with for a short time when the publisher goes offline. The publisher must be brought back online within a short time period.
Clustering is your best solution for your problem.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
August 18, 2005 at 1:16 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply