Backing up to a logical tape device - Transact-SQL
by Dinesh[ Edit ] 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
