O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

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' ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required