"0x80770006" and "3201" errors after you install an instance of SQL Server 2008 R2

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:For more information about VDI, view the VDI specification. The following file is available for download from the Microsoft Download Center:
Download Download the SQL Server 2005 Virtual Backup Device Interface (VDI) Specification package now. 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 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.
Vlastnosti

ID článku: 2618570 – Posledná kontrola: 26. 9. 2012 – Revízia: 1

Pripomienky