December 5, 2008 at 5:42 am
What is the best practice regards backing up mirrored servers.
Setting schelduled jobs on the principle server to perform full backups and regular log backups is no problem.
You cant do this on the mirrored server as the database is in recovery.
But what if the principle goes down causing the mirror to then take over.
Is it down to us to manually then start backup jobs on this box or can this be automated in any way?
Your thoughs and ideas appreciated.
December 5, 2008 at 7:55 am
Add a job step to check DB status (whether Online or Recovery/Mirror), then only start if it's Online
I seem to remember you can use Maint. Plans in Mirror Servers (or that it can magically failover to the Mirrored server as well?)
Mirroring 101
http://www.sqlservercentral.com/articles/SS2K5+-+High+Availability/3046/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply