Create Multiple Database Backups simultaneously

Today, I am sharing an excellent new feature in SQL Server 2005 which allows you to create multiple backup copies of a database by a single TSQL statement. This feature helps us to make simultaneous backups on separate devices to increase backup reliability. Following TSQL script backup AdventureWorks database to 3 separate devices:

USE master;

GO

BACKUP DATABASE AdventureWorks

TO DISK=‘C:\AW1.bak’ –Backup no. 1

MIRROR TO DISK=‘D:\AW2.bak’ –Backup no. 2

MIRROR TO DISK=‘E:\AW3.bak’ –Backup no. 3

WITH FORMAT;

GO