Microsoft® SQL Server 2012 Unleashed

Creating Backup Devices

You can create logical backup devices by using T-SQL or SSMS. The T-SQL command for creating these logical backup devices is sp_addumpdevice, which has the following syntax:

Click here to view code image

sp_addumpdevice [ @devtype = ] 'device_type'        , [ @logicalname = ] 'logical_name'        , [ @physicalname = ] 'physical_name'      [ , { [ @cntrltype = ] controller_type |          [ @devstatus = ] 'device_status' }      ]

The following sample script demonstrates the creation of the different types of backup devices:

Click here to view code image

-- Local DiskEXEC sp_addumpdevice 'disk', 'diskdev1',    'c:\mssql\backup\AdventureWorks2012.bak'-- Network DiskEXEC sp_addumpdevice 'disk', 'networkdev1',    '\\myserver\myshare\AdventureWorks2012.bak' ...