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

About changing distribution DB server Expand / Collapse
Author
Message
Posted Wednesday, July 3, 2013 7:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:28 AM
Points: 9, Visits: 104
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
Post #1470054
Posted Wednesday, July 3, 2013 8:32 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:28 AM
Points: 9, Visits: 104
I've tried restarted publisher SQL Server but still the same. It shouldn't be the cache issue then.
Post #1470287
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse