--- 创建备份数据的 device
USE master
EXEC
sp_addumpdevice
'disk'
,
'testBack'
'c:\mssqlBackup\database.dat'
--- 开始备份
BACKUP
DATABASE
pubs
TO
testBack