0

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?

Mark Henderson
  • 68,823
  • 31
  • 180
  • 259
  • Ohhh yes you can :P –  Dec 22 '09 at 08: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

1 Answers1

1

Have a look at the books available on the subject: http://oreilly.com/pub/topic/sqlserver

Particularly: http://oreilly.com/catalog/9780735626041/

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

therobyouknow
  • 471
  • 4
  • 8
  • 18