Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Location
    Simi Valley
    Posts
    2

    Question Unanswered: 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,
    Ryan

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Have you tried setting status with SP_RESETSTATUS and may use sp_helpreplicationdboption to get info. on replication.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Apr 2003
    Location
    Simi Valley
    Posts
    2
    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.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Use SP_REMOVEDBREPLICATION and then drop the database using DROP DATABASE statement. Then go for SP4.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •