Microsoft® SQL Server 2012 Unleashed

Mirrored Backups

The use of mirrored backups can help diminish the possibility of losing a database backup. Database backups can be your lifeline to recovery, and you do not want to lose them. Mirrored backups simultaneously write the backup information to more than one media set. You can mirror the backup to two, three, or four different media sets. Listing 11.5 gives an example of a mirrored backup that writes two different media sets.

LISTING 11.5 Creating a Mirrored Backup

Click here to view code image

BACKUP DATABASE AdventureWorks2012TO disk = 'C:\mssql\backup\AdventureWorks2012_Mirror1a.bak',   disk = 'C:\mssql\backup\AdventureWorks2012_Mirror1b.bak'MIRROR TO disk ='c:\mssql\backup\AdventureWorks2012_Mirror2a.bak',   disk = 'C:\mssql\backup\AdventureWorks2012_Mirror2b.bak' ...