日期:2014-05-17 浏览次数:20645 次
--请参考这个
BACKUP DATABASE Northwind TO
DISK = N'D:\SQL_BAK\db_bak\MSSQL_P\Northwind.bak' WITH NOFORMAT, NOINIT,
NAME = N'Northwind-完整 数据库 备份',
SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
BACKUP DATABASE [AdventureWorks2008R2] TO DISK = N'D:\AdventureWorks2008R2_20131108.bak' WITH NOFORMAT, NOINIT, NAME = N'AdventureWorks2008R2-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO