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.
T-SQL
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.