Backup Mirrored SQL Servers

The place to discuss any technical issues or suggestions in relation to BackupAssist v9.

Backup Mirrored SQL Servers

by tapicomms » Wed Dec 07, 2016 11:11 pm

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.
Posts: 1
Joined: Fri Jun 10, 2011 4:42 pm

Re: Backup Mirrored SQL Servers

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


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.
Should you have additional questions, please don't hesitate to contact me - I'd be glad to assist you.

Thank You,
Michael R. Jones
BackupAssist Help Desk
US Support New Albany, IN
User avatar
Cortex I.T.
Posts: 673
Joined: Tue Mar 09, 2010 8:04 am

Return to Technical Support v9

Who is online

Users browsing this forum: No registered users and 1 guest