Backup of Mirrored database

• Ray-422612

  Newbie

  Points: 6

  More actions

  January 9, 2009 at 6:04 am

  #195849

  What is the best way to handle backups on a mirrored database (sql 2005)?

  So far I've set up a full nightly backup on the principle server and transaction logs every 30 mins and also the same strategy on the mirrored server. I appreciate that the backups will only work on the server that has not failed over and therefore fail each time on the mirror. What happens if the principle server has been running for say 2 weeks and no backup has been taken on the mirror server in that time - then on day 14 the server fails over to the mirror - will the first transaction log backup taken be huge? Is there a better way of handling this?

• Sameer Raval

  Hall of Fame

  Points: 3214

  More actions

  January 9, 2009 at 11:08 am

  #924417

  Check Database Mirroring Role Change and Automatic Failover at

  http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

  and http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirfaq.mspx

  Kindest Regards,

  Sameer Raval [Sql Server DBA]
  Geico Insurance
  RavalSameer@hotmail.com