level 1
USE AdventureWorks2012;
GO
BACKUP DATABASE AdventureWorks2012
TO DISK = 'Z:\SQLServerBackups\AdventureWorks2012.Bak'
WITH FORMAT,
MEDIANAME = 'Z_SQLServerBackups',
NAME = 'Full Backup of AdventureWorks2012';
GO
更多请参照官方文档
https://msdn.microsoft.com/en-us/library/ms187510.aspx#TsqlProcedure
2015年04月28日 12点04分