Categories
Sql Server

Mirrored Backup In SQL Server

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.

12-21-2013 8-36-15 PM

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.