How to clean out Replication on DBRepaired DB

Hi all,

I had a suspect database that I had to kill.. it was non-recoverable.
The DB was a publisher and distributor for replication.
The Publications are still listed Enterprise Manager, the distribution database is still poopulated with publication info for this database.

Anyone know an easy way to clean out the replication info for the Dropped DB?

Thanks,
RyanHave you tried setting status with SP_RESETSTATUS and may use sp_helpreplicationdboption to get info. on replication.|||Yes, Thank you for replying.

I used SP_RESETSTATUS to set the status on the DB so it is not suspect.
I tried to kill replication at this point but it could not access the DB becasue the MDF file was corrupted. Nothing I could do would get the database recognizable...the recover function on start-up would consistantly fail because of a bad FCB on the file.

So I used the DBCC DBREPAIR command to kill the database...but in the replication monitor in Enterprise manager, the publications still exist for the non-existant DB. The Distribution database still contains info about those publications. Is there a Stored Procedure that anyone knows of to cleanup the distribution database?

I am also planning on applying SP4 to this SQL7 server..but have been waiting to clean up the databases first. Any thoughts?

Thank you so much to the DBFORUM community!

Ryan Jones

Originally posted by Satya
Have you tried setting status with SP_RESETSTATUS and may use sp_helpreplicationdboption to get info. on replication.|||Use SP_REMOVEDBREPLICATION and then drop the database using DROP DATABASE statement. Then go for SP4.