Tag Archives: Mirrored Backup In SQL Server 2012

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. T-SQL BACKUP DATABASE DEV TO DISK=’D:\DEV.bak MIRROR TO DISK = ‘E:\DEV.bak’ MIRROR