Avamar：SQL 重定向恢复到启用了 TDE 的数据库失败。

Summary: 由于在 SQL 数据库上启用了透明数据加密 （TDE），SQL 重定向恢复失败。

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

备份日志中显示以下错误：

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)

（请参阅“找不到服务器证书”）

Cause

由于缺少 TDE 证书，启用了 SQL 透明数据加密 （TDE） 的数据库会阻止重定向还原。 

Resolution

若要验证是否已在 SQL 数据库上启用 TDE，请使用 SQL 命令提示符查询数据库。
  • 如果启用了 TDE，则 "is_encrypted“是”1”
 
要解决此问题，必须在启动恢复之前手动将证书应用于 SQL 实例。 
  • 请咨询 Microsoft 以获得帮助。

Affected Products

Avamar, Avamar Plug-in for SQL

Products

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