Has anyone else had to repair a distribution database that was flagged 'suspect' in order to restore replication?
Imagine my surprise when I checked my SQL Server replication manager and discovered that replication had stopped!! Then I noticed that my distribution database was greyed out and had no items in it. When I tried to restore, I discovered that the backups were missing, as was the .mdf for the distribution db.
I could not restore from backup, and there appeared to be no .mdf to reattach. I have tried right-clicking on the database that was being replicated and selecting 'Disable publication', but since I could not access the distribution db, the process failed and I was stuck at square one.
I am running MSSQL 2K SP4 on Win2K3. Please help!!