此示例将创建用于存放 AdventureWorks 数据库完整备份的逻辑备份设备 AdvWorksData。-- 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
BACKUP DATABASE [MYDB] TO DISK = N'f:\bak\20090218.bak' WITH NOFORMAT, NOINIT, NAME = N'MYDB-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10这是用profiler看到的备份的语句。
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
刚才收缩了一下,只有30M了。备份后恢复也正常。谢谢各位。