数据库自动备份加时间标记
declare @filename nvarchar(254) set @filename='E:\DBDW'+convert(char(30),getdate(),112) BACKUP DATABASE [DBDW] TO DISK = @filename WITH NOINIT , NOUNLOAD , NAME = N'DBDW 备份', NOSKIP , STATS = 10, NOFORMAT
declare @filename nvarchar(256) set @filename='E:\DBStaging'+convert(char(30),getdate(),112) BACKUP DATABASE [DBStaging] TO DISK = @filename WITH NOINIT , NOUNLOAD , NAME = N'DBStaging 备份', NOSKIP , STATS = 10, NOFORMAT