Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Changing Distributor Expand / Collapse
Author
Message
Posted Monday, June 22, 2009 11:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 22, 2009 11:18 AM
Points: 1, Visits: 0
We have a SQL server that was renamed. Replication was enabled when the server was renamed. When I right click on replication folder and choose publisher properties, the distributor name is the old server. The sql server instance and distributor does not match.

There is also no distribution database.

How can I change the name or remove replication from the server and start over?
Post #739600
Posted Thursday, June 25, 2009 9:26 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, October 24, 2014 2:56 PM
Points: 362, Visits: 889
Try this:
sp_dropdistributor @no_checks=1,@ignore_distributor=1

(Read more on the SP here: http://msdn.microsoft.com/en-us/library/ms173516(SQL.90).aspx)


Kendal Van Dyke
http://kendalvandyke.blogspot.com/
Post #741908
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse