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 ?
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.