数据库通用作业备份方法

declare @filename nvarchar(100)
set @filename='E:\shenzhanwuliu\data'+convert(char(10),getdate(),112) print @filename
BACKUP DATABASE  SZMis
 TO DISK = @filename WITH NOINIT , NOUNLOAD ,
NAME = N'addin 备份', NOSKIP , STATS = 10, NOFORMAT