Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question

2 Answers 2

up vote 6 down vote accepted

I'd do a set partner suspend, then take the mirror down.

Some additional links:

Mirror backup & restore

Mirror backup script

share|improve this answer
    
Sounds reasonable. Should I also disable trans log backup on the principal while the mirror is down? –  deutschZuid Aug 24 '12 at 6:17
    
No you can continue to take your normal backups. But your tlog will not recover(reuse) space while the mirror is suspended. So if you are planning to have the mirror suspended for a while, this could = large tlog. When you resume the mirror, it will catch up. Suspend would be good for short term maintenance. If you know you need to be down for a while you may want to break the mirror. –  Eric Higgins Aug 24 '12 at 17:04

Theoretically you shouldn't do anything. Just take the mirror down, do the maintenance, then bring it back up. The whole purpose of the mirroring is to survive when something like that occurs accidentally, so it must survive it and recover fine when it occurs intentionally.

You can follow Eric's advise and set the partner suspend, but is not necessary. I wouldn't do it mostly because I'm more interested to see it if it does fail, and how it fails, but that is job conditionning on my side... So there is no harm in setting suspend.

You should continue to take log backups on the principal while the mirror is down. The principal knows the last LSN confirmed by the mirror before going down and will not truncate the log past that point.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.