Problem description
SQL Restore fails with VSS 1
Cause
Transparent data encryption(TDE) is enabled on SQL database
Traceback
Phoenix.log
SyncError: VSS writer has reported failure : [state = 13, result_code = -2147212300], writer details are = [writer class id : {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}, writer name : SqlServerWriter] (#100040001) (Error Code : VSS1)Log Name: Application Source: SQLWRITER Date: 07-02-2024 Event ID: 24583 Task Category: None Level: Error Keywords: Classic User: N/A Computer: abc.local Description: The description for Event ID 24583 from source SQLWRITER cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
ICommandText::Execute 0x80040e14 SQLSTATE: 42000, Native Error: 3013 Error state: 1, Severity: 16 Source: Microsoft OLE DB Driver for SQL Server Error message: RESTORE FILELIST is terminating abnormally. SQLSTATE: 42000, Native Error: 33111 Error state: 3, Severity: 16 Source: Microsoft OLE DB Driver for SQL Server Error message: Cannot find server certificate with thumbprint '0x65568B52C4B817B088E7ECEAD70CDCED87FC4E01'.
Verification
Please confirm TDE is enabled by running this query on the source SQL server.
select name,is_encrypted from sys.databases;
From the output, if the value of “is_encrypted” is “1” means the database is encrypted. The databases, tempdb and TDE_DB are encrypted.
Resolution
As a workaround, Perform the SQL Restore as database files.