Skip to main content
SQL Restore to alternate SQL Instance fails with VSS 1
Updated over a week ago

Problem description

SQL Restore fails with VSS 1


Transparent data encryption(TDE) is enabled on SQL database



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
Date: 07-02-2024
Event ID: 24583
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: abc.local
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:
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'.


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.


Did this answer your question?