Backing up a Mirror

• James Mace

  Ten Centuries

  Points: 1022

  More actions

  September 18, 2013 at 11:56 am

  #277314

  If you are mirroring a database, should you still run backups on the Mirror?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  September 18, 2013 at 12:44 pm

  #1651244

  You can't back up a mirror database.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• James Mace

  Ten Centuries

  Points: 1022

  More actions

  September 18, 2013 at 12:57 pm

  #1651253

  thanks much