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