-- Create a logical backup device for data backups of AdventureWorks.
USE master
GO
EXEC sp_addumpdevice 'disk', 'AdvWorksData',
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\BACKUP\AdvWorksData.bak'
-- Back up the full AdventureWorks database.
BACKUP DATABASE AdventureWorks
TO AdvWorksData