question

Hi Experts , I have SQL AGENT Job full backup job step DECLARE @fname NVARCHAR(100) = N'V:\Backup\XYZ_Q1_backup_' + CONVERT(NVARCHAR(10), SYSDATETIME(), 112 ) + N'.bak'; BACKUP DATABASE [XYZ] TO DISK = @fname WITH COMPRESSION, STATS = 10 DECLARE @backupSetId AS INT SELECT @backupSetId = position FROM msdb..backupset WHERE database_name=N'XYZ' AND backup_set_id = ( SELECT MAX( backup_set_id ) FROM msdb..backupset WHERE database_name=N'XYZ' ); IF @backupSetId IS NULL BEGIN RAISERROR( N'Verify failed. Backup information for database ''XYZ'' not found.', 16, 1 ) END RESTORE VERIFYONLY FROM DISK = @fname WITH FILE = @backupSetId i am getting error everytime it runs 10 percent processed. [SQLSTATE 01000] (Message 3211) 20 percent processed. [SQLSTATE 01000] (Message 3211) 30 percent processed. [SQLSTATE 01000] (Message 3211) 40 percent processed. [SQLSTATE 01000] (Message 3211) 50 percent processed. [SQLSTATE 01000] (Message 3211) 60 percent processed. [SQLSTATE 01000] (Message 3211) 70 percent processed. [SQLSTATE 01000] (Message 3211) 80 percent processed. [SQLSTATE 01000] (Message 3211) 90 percent processed. [SQLSTATE 01000] (Message 3211) Processed 256 pages for database 'XYZ', file 'XYZ_P' on file 1. [SQLSTATE 01000] (Message 4035) Processed 31158096 pages for database 'XYZ', file 'XYZ_F1' on file 1. [SQLSTATE 01000] (Message 4035) Processed 31181464 pages for database 'XYZ', file XYZ_F2' on file 1. [SQLSTATE 01000] (Message 4035) 100 percent processed. [SQLSTATE 01000] (Message 3211) Processed 98985 pages for database 'XYZ', file 'XYZ_log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP DATABASE successfully processed 62438801 pages in 2183.508 seconds (223.403 MB/sec). [SQLSTATE 01000] (Message 3014) Verify failed. Backup information for database 'XYZ' not found. [SQLSTATE 42000] (Error 50000). The step failed. what should i do to solve the problem ?