Backup of SharePoint or MOSS 2007 databases fails with the error: 0xe0008492 - Database Query Failure

Problem

Backup of SharePoint or MOSS 2007 databases fails with the following error.

Error Message

V-79-57344-33938 - An error occurred on a query to database DATABASENAME.

V-79-57344-33938 - Cannot open backup device 'DATABASENAME'. Operating system error 0x80070002 (The system cannot find the file specified.).

During the backup of MOSS 2007 or SharePoint Services 3.0 databases, the backup fails with the above error message.

The event Logs on the SQL Server may show the following error messages:

Log Name: Application
Source: SQLVDI
Event ID: 1
Level: Error
Description: SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=3848. Thread=5464. Client. Instance=OFFICESERVERS. VD=Global\DATABASENAME__SQLVDIMemoryName_0.

Log Name: Application
Source: SQLVDI
Event ID: 1
Level: Error
Description: SQLVDI: Loc=CVDS::Close. Desc=Abnormal termination state. ErrorCode=(0). Process=3848. Thread=5464. Client. Instance=OFFICESERVERS. VD=Global\DATABASENAME__SQLVDIMemoryName_0.
 

Cause

This issue is pertaining to the Microsoft SQLVDI (Virtual Device Interface) used by Backup Exec to backup SQL databases.
 

Solution


This issue is resolved by applying the following update to the SQL Server from Microsoft.

Microsoft SQL Server 2005 Backward Compatibility Components
 http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

Note: a reboot may be required after the update has been installed.
 

 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)