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

Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial