Mirrored Backups with SQL Server September 20th, 2010

Vinod Kumar

The Enterprise Edition of SQL Server 2005+ introduces the concepts – “mirroring of backup media sets” to provide redundancy of your critical database backups. Mirroring a media set increases backup reliability by reducing the impact of backup-device malfunctions. These malfunctions are very serious because backups are the last line of defense against data loss. SQL Server Standard Editions supports only a single backup copy during your backup operations. Depending on your requirements, Enterprise Edition allows you to create up to four mirrored media sets. An unique yet a powerful option.

Each disk file in the backup must have a corresponding file in the mirror media set. A crisis that required a database restore may have occurred. During the restore, if a the Backup file returned a critical error. Since the mirror files contain identical content, you are able to restore Backup easily. Without the mirrored files, your restore operation may have required database and log backups from many days or weeks earlier, which would significantly increase the time to restore and introduce more risk to the process.

Benefits: Mirrored backup media sets improve availability by minimizing downtime during restore operations. A damaged backup could result in a longer restore time, or a restore failure. As databases grow, the probability increases that the failure of a backup device or media will make a backup unrestorable. Restoring a database is time sensitive, and mirrored backup media sets give you added protection to get your application fully functional more quickly.

Tags: , , , , , ,

This entry was posted on Monday, September 20th, 2010 at 16:41 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply