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

Continuing transactional replication after mirror or log shipping failover Expand / Collapse
Author
Message
Posted Tuesday, August 27, 2013 12:34 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 6:11 AM
Points: 2, Visits: 543
We want to add a failover sever to our existing SQL 2005 Enterprise setup using database mirroring or log shipping. The database that we will be using is currently also used as a publisher and a subscriber for standard transactional replication, the distributor is another server entirely. My issue is having a seamless transition over to the failover server and have database continue as a publisher and subscriber and back again. Which method would be best and how would this be achieved.

Thanks
Post #1488904
Posted Thursday, August 29, 2013 1:08 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 10:00 AM
Points: 740, Visits: 1,541
In Replication Monitor find out Agent Profile for snapshot and Log reader Agent and in
-PublisherFailoverPartner type in mirror server name



Post #1489855
Posted Thursday, August 29, 2013 1:12 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 6:11 AM
Points: 2, Visits: 543
Markus Veretin (8/29/2013)
In Replication Monitor find out Agent Profile for snapshot and Log reader Agent and in
-PublisherFailoverPartner type in mirror server name


Thanks for your input, I am aware of this setting but wouldn't it only apply for the database being a publisher and not continue the replication as also being a subscriber?
Post #1489863
Posted Thursday, August 29, 2013 1:36 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 10:00 AM
Points: 740, Visits: 1,541
Not sure about local subscriber, try it, we have a mirror server in another US state, and after fail over to mirror replication worked fine.


Post #1489877
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse