Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

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


Group: General Forum Members
Last Login: Yesterday @ 4:30 PM
Points: 23, Visits: 107
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 that correcr ?

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