DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2618570 - Last Review: September 26, 2012 - Revision: 3.0

Symptom

Consider the following scenario:
  • You install an instance of Microsoft SQL Server 2008 R2 on a server that has instances of Microsoft SQL Server 2005 and Microsoft SQL Server 2008 installed.
    Note Some or all of the old instances are running at the installation time.
  • You try to perform a Virtual Backup Device Interface (VDI) backup of SQL Server 2005 or of SQL Server 2008.
In this scenario, the VDI backup operation fails. Additionally, the following errors are generated in the SQL Server logs:
<Error Time> Backup Error: 3201, Severity: 16, State: 7.
<Error Time> Backup Cannot open backup device '<Folder Location>'. Operating system error 0x80770006 (failed to retrieve text for this error. Reason: 15105).
Note In these errors, "Event Time" is a placeholder for the time that the error occurs, and "Folder Location" is a placeholder for the location of backup folder.

Cause

This problem occurs because the SQL Server server and the SQL Server client use different versions of the Sqlvdi.dll file when you perform a VDI backup operation.

When you install SQL Server 2008 R2, the on-disk copies of Sqlvdi.dll file in SQL Server 2005 or in SQL Server 2008 are overwritten by the Sqlvdi.dll file in SQL Server 2008 R2. However, the old version of the Sqlvdi.dll file remains in the memory when the instances are running during the installation.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Resolution

To resolve this issue, restart each older version of the instance of SQL Server that may have been running during the installation of SQL Server 2008 R2 instance. To prevent this problem, before you install SQL Server 2008 R2, follow these steps:
  1. Stop all instances of SQL Server on the server.
  2. Install SQL Server 2008 R2.
  3. Restart the instances of SQL Server that you stopped.

More Information

You can use SQL Server Backup Simulator to detect which version of the Sqlvdi.dll file is installed. For more information about how to use SQL Server Backup Simulator, go to the following Microsoft website:
General information about SQL Server Backup Simulator (http://blogs.msdn.com/b/sqlserverfaq/archive/2010/10/27/sql-server-backup-simulator.aspx)
For more information about VDI, view the VDI specification. The following file is available for download from the Microsoft Download Center:
Collapse this imageExpand this image
Download
Download the SQL Server 2005 Virtual Backup Device Interface (VDI) Specification package now. (http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=17282) For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591  (http://support.microsoft.com/kb/119591/ ) How to obtain Microsoft support files from online services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Applies to
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2005 Enterprise Edition
Keywords: 
kbsurveynew kbtshoot kbexpertiseadvanced atdownload KB2618570
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support