Article ID: 323602 - View products that this article applies to.
This article was previously published under Q323602
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/256986/EN-US/ )Description of the Microsoft Windows Registry
BUG #: 357231 (SHILOH_BUGS)
Backup or restore operations that use the SQL Server Virtual Device Interface (VDI) may not succeed and SQL Server logs one of the following errors in the SQL Server error log:
BackupVirtualDeviceSet::Initialize: CoCreateInstance failure on backup device 'TDPSQL-00000798-0000'. Operating system error -2147467262 (No such interface supported).
BackupVirtualDeviceSet::Initialize: CoCreateInstance failure on backup device 'TDPSQL-00000036-0000'. Operating system error -2147221163 (Interface not registered).
This problem occurs because a worker thread in SQL Server that was previously initialized in the Component Object Model (COM) has remained in a single-threaded apartment (STA). This worker thread then tries to load the SQL Server VDI. Because the SQL Server VDI is free threaded, it cannot be loaded to an STA, and one of error messages that is listed in the "Symptoms" section occur.
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
To change the registered threading model for the SQL Server VDI:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
For more information about how to use the SQL Server VDI, see the "Virtual Backup Device Samples" topic in SQL Server Books Online.
Article ID: 323602 - Last Review: December 1, 2005 - Revision: 3.3