I have a maintenance plan and SQL Server Agent job which takes the Full, Differential and Transaction Log Backup of some 80 Databases.
The Full and Transaction Log backup are taking up fine by my Differential backup is failing with the following error:
Failed:(-1073548784) Executing the query “declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N’MY_Database’ and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N’MY_Database’ )
if @backupSetId is null begin raiserror(N’Verify failed. Backup information for database ”MY_Database” not found.’, 16, 1) end
RESTORE VERIFYONLY FROM DISK = N’E:\\MSSQL.1\\MSSQL\\Backup\\MY_Database\\MY_Database_backup_200808190500.DIFF.BAK’ WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
” failed with the following error: “Cannot open backup device ‘E:\\MSSQL.1\\MSSQL\\Backup\\MY_Database\\MY_Database_backup_200808190500.DIFF.BAK’. Operating system error 2(The system cannot find the file specified.).
VERIFY DATABASE is terminating abnormally.”. Possible failure reasons: Problems with the query, “ResultSet” property not set correctly, parameters not set correctly, or connection not established correctly.
Please let me know how to fix this issue.