Post reply

Unreplicate a database

  • July 7, 2004 at 9:46 am

    #161671

     

    How do I unreplicate a single database set up for replication in SQL2000?

    Thanks

  • July 7, 2004 at 10:14 am

    #513685

    One option would be to execute the store procedure sp_removedbreplication from query analyzer. Books on-line has the references to this SP.

     

    Johnny Johnson

    Open Software Solutions, Inc.

     

    This and 25¢ will get you a cheap cup of coffee.

  • July 7, 2004 at 10:37 am

    #513687

    If the sp_removedbreplication doesn't work try the steps below. Note: You should make sure you have a good backup before trying this. This comes from KB 326352: You Receive Error 3724 When You Drop a Non-Replicated Object

    I would suggest reading the article first befor trying the steps below.

    use %dbname%
go
sp_configure 'allow updates', 1
go
reconfigure with override
go
begin transaction
 update %dbname%..sysobjects 
 set replinfo = 0
 where name = '%object_name%'
commit transaction
go



    ----------------
    Jim P.

    A little bit of this and a little byte of that can cause bloatware.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply