When running SQL 2000 database job, databases are skipped and gives an error Database was not found, or could not be accessed

Article:TECH75980

Created: 2009-01-26

Updated: 2012-05-14

Article URL http://www.symantec.com/docs/TECH75980

Article Type
Technical Solution

Product(s)

Show all

Subject

Show all

Languages

Show all

Problem

When running SQL 2000 database job, databases are skipped and gives an error Database was not found, or could not be accessed

Error

Database . was not found, or could not be accessed.

The Remote Agent debug log (see Related Document) displays the following message:

[2820] 10:33.39 returning msdb

[2820] 10:33:39 Using the Virtual Device mechanism for the backup operation.

[2820] 10:33:39 VDI Open Timeout set to INFINITE

[2820] 10:33:39 VDI Buffer Timeout set to INFINITE

[2820] 10:33:39 Error calling CoCreateInstance: x8007007E

[2820] 10:33:39 Failed the Virtual Device allocation for backup operation.

[2820] 10:33:39 Destroying VirtualDeviceSet

[2820] 10:33:39 Informational, no operation thread handle to close.

[2820] 10:33:39 Informational - cannot deallocate Virtual Device object.

[2820] 09/16/05 10:33:39 LP_ENV::MsgError: error 0xe00084af processing object |msdb.

Cause

The error message is a result of a Virtual Device Interface (VDI) failure on the SQL machine. Backup Exec 10.x and above only uses VDI for backups of Microsoft SQL.

Solution

Workaround 1:

To resolve this problem, re-register the SQLVDI.DLL as follow:

1) Stop the SQL(BKUPEXEC) service.

2) Locate the SQLVDI.DLL path (the default path for SQL 2000 is \Program Files\Microsoft SQL Server\80\COM and for SQL 7.0 is \Mssql7\Bin).

3) Type "regsvr32 <path>\SQLVDI.DLL" .

4) Start the SQL(BKUPEXEC) Service.

Workaround 2:

Since SQL backups are done using the VDI provided by Microsoft an updated version of VDI is required to complete the backup.

Please apply the following patch from Microsoft to the SQL Server to resolve the issue.

http://support.microsoft.com/?kbid=913100

Supplemental Materials

Source	UMI
Value	V-79-57344-65268
Description	AOFO: Initialization failure on: "SQL Server Name". Advanced Open File Option used: Microsoft Volume Shadow Copy Service (VSS).