Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Disabling Distribution DB

Author  Topic 

bg1987
Starting Member

1 Post

Posted - 2008-05-28 : 09:08:23
I have accidentally registered an existing database as a distribution database, which made it a system database.
the data itself is safe and sound, but I want to undo the whole thing.

How can I do this?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-28 : 09:48:31
Distribution Database is a system database for Replication.
see sp_changedistributiondb in Books online. Or you can disable distributor and start all over again.
Go to Top of Page
   

- Advertisement -