设置sql作业任务按日期标注备份文件T-SQL语句

设置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 …

05/31/2012 0条评论 1262点热度 0人点赞 guangjie 阅读全文