Viewing post 1 (of 1 total)
You can do this in this way.
Declare @Datestamp as varchar(10)
SET @Datestamp=Convert(varchar(8),getdate(),112)
EXEC('BACKUP DATABASE [ReportServer]
TO DISK = ''D:\MSSQL\BAK\ReportServer'+ @Datestamp+'.BAK''
WITH FORMAT, COMPRESSION')
November 24, 2012 at 7:27 pm
#1562016