Backup/mirroring

• arkiboys

  Hall of Fame

  Points: 3958

  More actions

  November 6, 2012 at 1:08 am

  #284525

  Our sql server databases are being mirrored to another server.

  We are also taking regular end of day backups.

  Question:

  Is it necessary to do backups since mirroring is in place or vice versa?

  Thanks

• Perry Whittle

  SSC Guru

  Points: 234040

  More actions

  November 6, 2012 at 1:29 am

  #1556347

  arkiboys (11/6/2012)

  ---

  Our sql server databases are being mirrored to another server.

  We are also taking regular end of day backups.

  Question:

  Is it necessary to do backups since mirroring is in place or vice versa?

  Thanks

  Yes, you should always take backups, especially since mirroring requires a full and log backup to initialise to begin with

  Mirroring provides availability not recovery

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs"

• jasonmorris

  SSCrazy

  Points: 2492

  More actions

  November 9, 2012 at 7:26 am

  #1557599

  Mirroring won't protect you from data corruption / loss but backups can.

• arkiboys

  Hall of Fame

  Points: 3958

  More actions

  November 10, 2012 at 2:24 am

  #1557895

  I see.

  Thank you