Changing Distributor

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » Changing Distributor

Changing Distributor

Rate Topic

Display Mode

Topic Options

Author

Message

cnadler3-1118456

Posted Monday, June 22, 2009 11:19 AM

Forum 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

Kendal Van Dyke

Posted Thursday, June 25, 2009 9:26 AM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 2:58 PM
Points: 361, Visits: 780

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 »

Permissions