This topic describes how to define a logical backup device for a tape drive in SQL Server 2012 by using SQL Server Management Studio or Transact-SQL. A logical device is a user-defined name that points to a specific physical backup device (a disk file or tape drive). The initialization of the physical device occurs later, when a backup is written to the backup device.
.gif)
Note
|
|---|
|
Support for tape backup devices will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. |
In This Topic
-
Before you begin:
Limitations and Restrictions
Security
-
To define a logical backup device for a tape drive, using:
SQL Server Management Studio
Transact-SQL
To define a logical backup device for a tape drive
-
After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.
-
Expand Server Objects, and then right-click Backup Devices.
-
Click New Backup Device, which opens the Backup Device dialog box.
-
Enter a device name.
-
For the destination, click Tape and select a tape drive that is not already associated with another backup device. If no such tape drives are available, the Tape option is inactive.
-
To define the new device, click OK.
To back up to this new device, add it to the Back up to: field in the Back up Database (General) dialog box. For more information, see Create a Full Database Backup (SQL Server).
.gif)
[Top]
To define a logical backup device for a tape drive
-
Connect to the Database Engine.
-
From the Standard bar, click New Query.
-
Copy and paste the following example into the query window and click Execute. This example shows how to use sp_addumpdevice to define a logical backup device for a tape. The example adds the tape backup device named tapedump1, with the physical name \\.\tape0.
USE AdventureWorks2012 ;
GO
EXEC sp_addumpdevice 'tape', 'tapedump1', '\\.\tape0' ;
GO
[Top]
.png)
