Avamar：SQL 重新導向還原無法至啟用 TDE 的資料庫。

Summary: SQL 重新導向還原失敗，因為 SQL 資料庫已啟用透明資料加密 （TDE）。

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

啟用 SQL 透明數據加密 （TDE） 的資料庫可防止由於缺少 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.