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:
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:
-- Local DiskEXEC sp_addumpdevice 'disk', 'diskdev1', 'c:\mssql\backup\AdventureWorks2012.bak'-- Network DiskEXEC sp_addumpdevice 'disk', 'networkdev1', '\\myserver\myshare\AdventureWorks2012.bak' ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.