Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have replicated two database in SQL2008.

The last two days the distribution database from publisher server changed to Suspect Mode and the replication process is down.

I read a lot from Google and tried to repair, but without success.

During my repairing process, the Distribution Database is has changed to Emergency mode.

Can anyone please kindly suggest any solutions?

share|improve this question

migrated from Dec 22 '09 at 8:40

This question came from our site for professional and enthusiast programmers.

Ohhh yes you can :P – S M Kamran Dec 22 '09 at 8:34
Please let us know more about your replication-setup (snapshot / transactional / merge). What can read out of the log-files? Have a look at tempdb, is it healthy? How long is the system up and running (days/weeks/months) or more? How did you try to repair? and last but not least, is there free disk capacity on the disk where the distribution database lies. good luck. – Ice Mar 31 '10 at 21:13

Have a look at the books available on the subject:


Try to make your question title more specific - this will get more attention and hopefully more answers to choose from!

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.