Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

remove distribution database

Status
Not open for further replies.

maswien

Technical User
Joined
Sep 24, 2003
Messages
1,286
Location
CA
I want clean all the replication configuration in my SQL Server, I succeeded in cleaning up replication
folder and deleted all the replication related agents. Only the distribution database I couldn't remove it from
the enterprise manager, can anybody tell me how to do it? Thanks
 

I manually removed the distribution database, then when I tried to using the replication wizard 'configure publishing, subscribing and distributing' to setup a new replication, I got error message like:

Code:
SQL Server Enterprise Manager couldn't complete this operation. Error 21769:[SQL-DMO] The passed ordinal is out of the specified collection.

It looks like something still not cleaned yet, any idea? Thanks
 

In above comment, 'manually' meant I remove it from sysdatabases table in master database. I know I didn't do it right, so that's why I got the error.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top