patternMinor
What happens when the mirroring server goes offline (for a short while)?
Viewed 0 times
thewhilewhatservershortgoesofflineformirroringhappens
Problem
Let's say we have a principal server, a mirroring server (the one that serves as the failover backup) and a witness server.
Does it matter if I were to bring the mirroring server (not the principal) offline for a short while (five minutes, let's say). Is this going to break the mirror? Is there anything I need to do (such as turning the mirroring off temporarily on the mirrored databases) before I take the server offline?
There are plenty of resources online to explain what needs to happen when the principal goes down, but nothing I can find about this scenario.
Does it matter if I were to bring the mirroring server (not the principal) offline for a short while (five minutes, let's say). Is this going to break the mirror? Is there anything I need to do (such as turning the mirroring off temporarily on the mirrored databases) before I take the server offline?
There are plenty of resources online to explain what needs to happen when the principal goes down, but nothing I can find about this scenario.
Solution
I'd do a set partner suspend, then take the mirror down.
Some additional links:
Mirror backup & restore
Mirror backup script
Some additional links:
Mirror backup & restore
Mirror backup script
Context
StackExchange Database Administrators Q#23058, answer score: 8
Revisions (0)
No revisions yet.