Back Up to a Mirrored Media Set (Transact-SQL)
Applies to: SQL Server
This topic describes how to use the Transact-SQL BACKUP statement to specify a mirrored media set when backing up a SQL Server 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 AdventureWorks2022
database to both mirrors.
BACKUP DATABASE AdventureWorks2022
TO TAPE = '\\.\tape0', TAPE = '\\.\tape1'
MIRROR TO TAPE = '\\.\tape2', TAPE = '\\.\tape3'
WITH
FORMAT,
MEDIANAME = 'AdventureWorks2022Set1';
GO
Related Tasks
To restore from a mirrored backup
See Also
BACKUP (Transact-SQL)
Mirrored Backup Media Sets (SQL Server)
Pripomienky
https://aka.ms/ContentUserFeedback.
Pripravujeme: V priebehu roka 2024 postupne zrušíme službu Problémy v službe GitHub ako mechanizmus pripomienok týkajúcich sa obsahu a nahradíme ju novým systémom pripomienok. Ďalšie informácie nájdete na stránke:Odoslať a zobraziť pripomienky pre