备份数据库sql语句

DECLARE @strPath NVARCHAR(200) 
set @strPath = convert(NVARCHAR(19),getdate(),102 ) 
set @strPath = 'D:\DataBase_' + @strPath + '.bak' 
BACKUP DATABASE [DataBase] TO DISK = @strPath WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT 
原文地址:https://www.cnblogs.com/liwenyan/p/3040409.html