Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    near Chicago

    Question Unanswered: 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 Admin

  2. #2
    Join Date
    Feb 2003
    It will pick up from where it left of when you shut it down. You may receive some errors in your system log.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts