The SQLVDI Problem is Reported During Backup of the MS SQL Server 2000 on Windows 2008

Publication Date:  2012-07-19 Views:  581 Downloads:  0
Issue Description
The Backup Exec is used to backup the MS SQL Server 2000 on Windows 2008. The backup job fails, and the following error message is displayed:
Completion status: failed
Final error: 0xe000035c - Microsoft SQL Server VDI initialization failed. This problem occurs because the required SQL Service Pack or hot fixes are not installed. Running the SQLExpress on Windows Vista or Windows Server 2008 requires the Service Pack 2 and hot fix v4 or a later version.
Final error category: resource error
For more information about this error, refer to the V-79-57344-860 link.  
Alarm Information
None
Handling Process
Step 1  Based on the onsite conditions, provide the upgrade to SQL 2005 solution and the rollback to Windows2003 solution.
Step 2  Use the rollback to Windows 2003 solution after discussion.
Step 3  Back up the SQL 2000 on Windows 2003.  
Root Cause
When the backup software processes a backup job, the underlying software calls the corresponding system interfaces by using scripts and commands. When the Backup Exec backs up Microsoft SQL Server, it requires the VDI.
The corresponding content of the V-79-57344-860 link indicates that Microsoft provides patches for the SQL Server 2005, but no patch for the SQL Server 2000, which is an earlier version. Users can require Microsoft to provide patches for the SQL Server 2000 on telephone (no attempt has been made because no service is bought from Microsoft).
The software compatibility list of the Windows 2008 clearly states that Windows 2008 is incompatible with Microsoft SQL Server 2000.  
Suggestions
The suggested solution based on the actual conditions is as follows:
(a) Upgrade Microsoft SQL Server 2000 to Microsoft SQL Server 2005.
(b) Roll Windows 2008 back to Windows 2003.
(C) Use Microsoft SQL Server 2000 to locally back up the data. Then use the Backup Exec to regularly back up the local backup.

END