About changing distribution DB server

• jiangrj1

  Old Hand

  Points: 347

  More actions

  July 3, 2013 at 7:39 am

  #274922

  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

• jiangrj1

  Old Hand

  Points: 347

  More actions

  July 3, 2013 at 8:32 pm

  #1629722

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