Mirrored Backup In SQL Server
In this post we will learn about what is Mirrored Backup In SQL Server.Mirrored backups are a new feature in SQL Server 2005 that allow you to write the same backup file to multiple locations, as illustrates in below image.
BACKUP DATABASE DEV TO DISK='D:\DEV.bak MIRROR TO DISK = 'E:\DEV.bak' MIRROR TO DISK = 'F:\DEV.bak' WITH INIT,CHECKSUM,CONTINUE_ON_ERROR
The one restriction to backing up to multiple locations is that the underlying devices
must be identical.