Friday, March 30, 2012

merge replication, what hapens if...

We have 2 SQL2000 servers updating in real-time using merge replication. I need to shut one server down over this weekend, but the other one needs to remain up. What will happen? Will we have to replicate all the data all over again or will it pick up where it left off?

If I'd have to re-replicate everything, can I prevent this by stopping a service or setting a replication schedule instead or something?

Thanks for your help,
Erica <-- not a SQL AdminIt will pick up from where it left of when you shut it down. You may receive some errors in your system log.

No comments:

Post a Comment