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?
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!