Errors: "Restore failing Not a Valid Microsoft Tape Backup Set" and "The SQL Server option 'Light
The error "Restore failing Not a Valid Microsoft Tape Backup Set" occurs when trying to restore and the following output is produced in Query Analyzer:
"EXEC master.dbo.xp_sqllitespeed_version in Query Analyzer output: The SQL Server option 'Lightweight pooling' is enabled! This option cannot be set when using SQL Litespeed. Please disable this option, or use the SQL Litespeed command line."
NT fibers or hyper threading may be enabled or may have been enabled at one time.
Run the following script in Query Analyzer:
sp_configure 'show advanced options', 1 RECONFIGURE WITH OVERRIDE GO sp_configure 'lightweight pooling', 0 RECONFIGURE WITH OVERRIDE GO
Stop and restart the SQL Server Service and the Agent Service. If the error still appears, use a DBCC DROPCLEANBUFFERS in Query Analyzer to clear out SQL Server's cache without rebooting the server. If the error still appears the server will need to be bounced.