1 declare @filename varchar(255)
 2 
 3 declare @date datetime
 4  
 5 select @date=getdate()
 6 select @filename='D:\backup\SQL-'+CAST(DATEPART(yyyy,@date) as varchar)+'-'+CAST(DATEPART(mm,@date) as
 7  
 8 varchar)+'-'+CAST(DATEPART(dd,@date) as varchar)+'.bak'
 9  
10 backup database abc to disk=@filename with init
11 go

执行后显示备份脚本可如下