SQL Backup to disk failes: 0xe0008492 - Database Query Failure

Suddenly one of our SQL backup to disk jobs have started to fail. The backup takes backup of about 8GB of a total 66GB (msdb, masterand the SAP (DPP) database). We get the following message:

0xe0008492 - Database Query Failure. See the job log for details.
V-79-57344-33938 - An error occurred on a query to database msdb.
V-79-57344-33938 - BACKUP DATABASE is terminating abnormally.
V-79-57344-33938 - An error occurred on a query to database master.
V-79-57344-33938 - BACKUP DATABASE is terminating abnormally.
V-79-57344-33938 - An error occurred on a query to database DPP.
V-79-57344-33938 - BACKUP DATABASE is terminating abnormally.

We have checked the following:
http://seer.entsupport.symantec.com/docs/273360.htm
There is no SQL 7.0 server, only SQL 2000.

and http://seer.entsupport.symantec.com/docs/237456.htm (assumed the we should edit registry only the target Sql server).

The backup to tape seams to be ok so the problem is mainly on the backup to disk witch is the daily job.

In the SQL log we get the following messages:
"BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'DPP_00__d1fb1311_bfe1_4d00_af8d_a5252a78bf17_'. Operating system error 995(error not found)."
and
"BackupVirtualDeviceFile::ClearError: failure on backup device 'DPP_00__d1fb1311_bfe1_4d00_af8d_a5252a78bf17_'. Operating system error 995(error not found)."

Could someone please help ASAP?
1 Reply

Re: SQL Backup to disk failes: 0xe0008492 - Database Query Failure

Hi,

Is there enough disk space on the Backup to disk folder for the job..?

Error 995 means -The SQL API is trying to create the virtual device and it is needing virtual memory and/or physical memory in order to do so.


Try backing up a few databases in one job. Also make sure that NT file system of the SQL server is not being backed up in the same job.

Check for any SQL errors that are being logged before the Error 995 is logged in event log.

Regards
Padmaja