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

Transaction replication with mirroring Expand / Collapse
Author
Message
Posted Tuesday, August 21, 2012 1:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 16, 2013 2:14 PM
Points: 5, Visits: 18
Hello friends

I need some help and I am sure ...i will find some here .

We have got SQL 2K8 setup and are using Transactional replication with mirroring .

We have configured the failover partner option for the logreader profile and it wrks gwoks . We have got to failover from the prinicprinciplee Mirror and keep the replication working .

The challenge is I need to reboot the Initllay priniciple ( now mirored server ) . I did went through the below article ...but it appears that once I reboot the prinicple server ....the replication is going to break .....is that correcr ?





http://msdn.microsoft.com/en-us/library/ms151799.aspx



Replication Behavior if Mirroring is Removed


Keep the following issues in mind if database mirroring is removed from a published database:


If the publication database fails over from the principal to the mirror and the mirroring relationship is subsequently disabled or removed, replication agents will not function against the mirror. If the principal is permanently lost, disable and then reconfigure replication with the mirror specified as the Publisher.

Post #1347607
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse