数据库自动备份加时间标记

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

转载于:https://www.cnblogs.com/Jasper-Wang/archive/2006/07/13/449843.html