About changing distribution DB server

  • Hi,

    I've encountered a problem when I re-setup the transaction replication. I want to change the distribution DB to another server. But somehow it always link to the old distribution DB server.

    My checking query is the below script, it always return the data in the old distributor db instead of the new one.

    select * from distribution..MSsubscriptions where publisher_db='...'

    select * from distribution..MSpublications where publisher_db='...'

    I even deleted the old link server in the publisher server but still not working. I don't understand where stored the old distribution server name in the publisher. I guess I haven't totally cleaned the old replication possible or the old distribution db store in the cache?

    Regards

    Billy

  • I've tried restarted publisher SQL Server but still the same. It shouldn't be the cache issue then.

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

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