Page 1 of 1

Backup Mirrored SQL Servers

Posted: Wed Dec 07, 2016 11:11 pm
by tapicomms
Have just setup mirroring on 2 servers, when server A (Principal) fails and it fails over to Server B (Mirror) are there any settings to ignore those databases that are in the recovery state?
Can we run a script before starting the backup, if the server is available run the job, if it’s not stop the job.
Do that on both backups jobs.
Then it should only do the backup on the server that is available.

Re: Backup Mirrored SQL Servers

Posted: Mon Feb 20, 2017 8:52 pm
by michael.jones

I've not been asked this particular question before.

But, yes, I believe running a proper script before the backup would be the way I would deal with it.