September 22, 2016 at 11:16 am
We have an environment with SQL cluster (2008R2) (node1 & 2) for failover clustering and Database mirror for Disaster recover(DR) High performance mode with no witness server . We are planning to do shared drive Disk maintenance on sql cluster and planning to shutdown sql cluster.
Please let me know any affect to DB mirror if I shut down the SQL cluster for Disk maintenance on principal.
Thanks in advance.
September 22, 2016 at 2:03 pm
If you are completely shutting down the cluster (within Failover Cluster Manager) both of the sql services on all nodes within the cluster will be stopped. As soon as the cluster is brought back online, the mirror should continue (re-sync) itself with no issues. However, it may not be a bad idea to pause the mirroring prior to the shutdown. This (pausing) can be done on the principal in SSMS or by TSQL. If you do the pausing, remember to un-pause (resume) the mirroring after the cluster is brought back online.
September 22, 2016 at 2:32 pm
Thank you RVSC48
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply