Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: Distribution Server - Replication

    What happens when Distributor Server goes down in Transactional
    Replication, no corruption (power , hardware failure)??


  2. #2
    Join Date
    Sep 2003
    Dallas, Texas
    Can you bring the distributor back up or the distribution database is lost? Before you bring the distributor back up, you need to shut down all subscriptions. If you can restart the distributor, you need to stop the logreader right after you have started the SQL Agent on the distributor. Open the subscription first to see if they can be synced. If the subscription doesn't errored out, open the logreader. Good luck!
    Last edited by joejcheng; 08-25-04 at 11:32.

Posting Permissions

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