DECLARE @strPath NVARCHAR(200) set @strPath = convert(NVARCHAR(19),getdate(),102 ) set @strPath = 'D:\DataBase_' + @strPath + '.bak' BACKUP DATABASE [DataBase] TO DISK = @strPath WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
DECLARE @strPath NVARCHAR(200) set @strPath = convert(NVARCHAR(19),getdate(),102 ) set @strPath = 'D:\DataBase_' + @strPath + '.bak' BACKUP DATABASE [DataBase] TO DISK = @strPath WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT