Changing Distributor

  • 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?

  • 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/[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply