Error message received when attempting to backup a database:
"SQL Server has returned a failure message to LiteSpeed 2005 which has prevented the operation from succeeding.
The following message is not a LiteSpeed 2005 message. Please refer to SQL Server books online or Microsoft technical support for a solution:
BACKUP DATABASE is terminating abnormally."
Here what would show in the SQL Server error log:
"2006-10-30 13:46:59.02 spid79 BackupVirtualDeviceSet::Initialize: CoCreateInstance failure on backup device 'VDI_00F9C69E-D002-4A92-A1E0-D04FEAC4593D_0'. Operating system error 0x80004002(No such interface supported).
2006-10-30 13:46:59.02 backup BACKUP failed to complete the command BACKUP database [alert_db] TO VIRTUAL_DEVICE='VDI_00F9C69E-D002-4A92-A1E0-D04FEAC4593D_0', VIRTUAL_DEVICE='VDI_00F9C69E-D002-4A92-A1E0-D04FEAC4593D_1', VIRTUAL_DEVICE='VDI_00F9C69E-D002-4A92-A1E0-D04FEAC4593D_2', VIRTUAL_DEVICE='VDI_00F9C69E-D002-4A92-A1E
This is a software bug in the Microsoft registry entries for SQL Server 7.0 and 2000.
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.
For additional information, see Microsoft KB article 323602 which gives the fix: