Backing up to a logical tape device - Transact-SQL

by Dinesh 2014-04-03 16:49:59

Backing up to a logical tape device - Transact-SQL

The following example creates a logical backup device for a tape drive. The example then backs up the complete AdventureWorks2012 database to that device.


-- Create a logical backup device,
-- AdventureWorks2012_Bak_Tape, for tape device . ape0.
USE master;
GO
EXEC sp_addumpdevice 'tape', 'AdventureWorks2012_Bak_Tape', '. ape0';
USE AdventureWorks2012;
GO
BACKUP DATABASE AdventureWorks2012
TO AdventureWorks2012_Bak_Tape
WITH FORMAT,
MEDIANAME = 'AdventureWorks2012_Bak_Tape',
MEDIADESCRIPTION = '. ape0',
NAME = 'Full Backup of AdventureWorks2012';
GO

827
like
0
dislike
0
mail
flag

You must LOGIN to add comments