SQL SERVER – Mirrored Backup Introduction and Explanation | Journey to SQL Authority with Pinal Dave

SQL Server 2005 Enterprise Edition and Development Edition supports mirrored backup. Mirroring a media set increases backup reliability by adding redundancy of backup media which effectively reduces the impact of backup-device failing. While taking backup of database, same backup is taken on multiple media or locations. T-SQL code to take Mirrored Backup : BACKUP DATABASE… Continue Reading...

Source: SQL SERVER – Mirrored Backup Introduction and Explanation | Journey to SQL Authority with Pinal Dave