Avamar: SQL Redirected restore fails to TDE enabled database.

Summary: SQL redirected restore fails due to Transparent Data Encryption (TDE) being enabled on SQL databases.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

The following errors show in the backup log:

avsql Error <40258>: sqlconnectimpl_smo::execute Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: Cannot find server certificate with thumbprint '0x4249D087641E4C7F4D311A3144A229851857F263'. RESTORE DATABASE is terminating abnormally. at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException) at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand) --- End of inner exception stack trace --- at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand) at SMOWrap.SMO_ExecuteWithResults(SMOWrap* , Char* sql_cmd, vector<std::basic_string<wchar_t\,std::char_traits<wchar_t>\,std::allocator<wchar_t> >\,std::allocator<std::basic_string<wchar_t\,std::char_traits<wchar_t>\,std::allocator<wchar_t> > > >* messages)

(See "Cannot find server certificate")

Cause

An SQL Transparent Data Encryption (TDE) enabled database prevents a redirected restore due to the missing TDE certificate. 

Resolution

To verify TDE is enabled on an SQL database, query the database using SQL command prompt.
  • If TDE is enabled, then "is_encrypted" is "1"
 
To resolve this issue, the certificate must manually be applied to the SQL instance prior to initiating the restore. 
  • Consult Microsoft for assistance.

Affected Products

Avamar, Avamar Plug-in for SQL

Products

Avamar
Article Properties
Article Number: 000052697
Article Type: Solution
Last Modified: 23 أبريل 2026
Version:  5
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.