Skip to content

back-up-to-a-mirrored-media-set-transact-sql.md

Latest commit

 

History

History
40 lines (33 loc) · 1.78 KB

back-up-to-a-mirrored-media-set-transact-sql.md

File metadata and controls

40 lines (33 loc) · 1.78 KB
title Back Up to a Mirrored Media Set (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql
ms.prod_service backup-restore
ms.reviewer
ms.technology backup-restore
ms.topic conceptual
ms.assetid 5fc43a5d-dfd6-4c53-a4ef-3c8da23ccc81
author MikeRayMSFT
ms.author mikeray

Back Up to a Mirrored Media Set (Transact-SQL)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] This topic describes how to use the [!INCLUDEtsql] BACKUP statement to specify a mirrored media set when backing up a [!INCLUDEssNoVersion] database. In your BACKUP statement, specify the first mirror in the TO clause. Then, specify each mirror in its own MIRROR TO clause. The TO and MIRROR TO clauses must specify the same number and type of backup devices.

Example

The following example creates the mirrored media set illustrated in the previous illustration and backs up the [!INCLUDEssSampleDBobject] database to both mirrors.

BACKUP DATABASE AdventureWorks2012  
TO TAPE = '\\.\tape0', TAPE = '\\.\tape1'  
MIRROR TO TAPE = '\\.\tape2', TAPE = '\\.\tape3'  
WITH  
    FORMAT,  
    MEDIANAME = 'AdventureWorks2012Set1';  
GO

Related Tasks

To restore from a mirrored backup

See Also

BACKUP (Transact-SQL)
Mirrored Backup Media Sets (SQL Server)