Skip to main content


 

 

How can we help you?

 

Druva Documentation

SQL Restore to alternate SQL Instance fails with VSS 1

Heads up!

We've transitioned to a new documentation portal to serve you better. Access the latest content by clicking here.

 

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;

Picture3.png
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

  • Was this article helpful?