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)
 HELP!!! Unable to configure distribution database

Author  Topic 

calygirl
Starting Member

1 Post

Posted - 2008-09-18 : 15:43:42
Help!!

I had originally setup transactional replication on a prod server and it was working great, but I had to remove it due to some issues with the application/schema. Unfortunately, I did not use the Wizard to remove the publisher/distributor and now when I try to reconfigure the distributor I get this error message:

The specified @name (‘Replication Warning’) Transactional replication latency already exists. Changed DB context to master error: 14261

Any fix for this without interrupting the prod server?

SimpleSQL
Yak Posting Veteran

85 Posts

Posted - 2008-10-11 : 03:53:45
You can use
following SP, but use it with CAUTION, if you have any other replication setup on the server.

sp_removedbreplication (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms188734.aspx

Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-10-13 : 19:38:45
Did you use Disable Distributor and Pub wizard to remove it?
Go to Top of Page
   

- Advertisement -