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)

Subject

Issue



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.
 

Supplemental Materials

SourceUMI
ValueV-79-57344-65268
Description

AOFO: Initialization failure on: "SQL Server Name". Advanced Open File Option used: Microsoft Volume Shadow Copy Service (VSS).


SourceUMI
ValueV-79-10000-10896
Description

SQL Prepare for Freeze failed for snapshot.




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


Terms of use for this information are found in Legal Notices