scripting restore job
Line 5: Incorrect syntax near 'master'
Here is the script:
declare @filename varchar(100)
declare @todaydate varchar(13)
set @filename = 'd:\program files\microsoft sql server\mssql\backup\'+@todaydate
master..sqlbackup N'-SQL "RESTORE DATABASE [XXXXX]
FROM DISK = @filename WITH RECOVERY, REPLACE"'
Any suggestions on this would be greatly appreciated.