SQL Restore to alternate SQL Instance fails with VSS 1
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.
- Also refer: Transparent data encryption (TDE) - SQL Server | Microsoft Learn