设置sql作业任务按日期标注备份文件的T-SQL语句 DECLARE @fileName varchar(256) set @fileName='e:\Backup\'+convert(NVARCHAR(10),getdate(),120)+'_database.bak' BACKUP DATABASE [database] TO DISK = @fileName WITH INIT , NOUNLOAD , NAME = N'database 备份', NOSKIP , STATS = 10, NOFORMAT …
