Avamar: SQL-omdirigeret gendannelse mislykkes til TDE-aktiveret database.

Summary: Gendannelse af omdirigeret SQL-drev mislykkes, fordi TDE (Transparent Data Encryption) er aktiveret på SQL-databaser.

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

Følgende fejl vises i sikkerhedskopieringsloggen:

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)

(Se "Kan ikke finde servercertifikat")

Cause

En SQL Transparent Data Encryption-aktiveret database (TDE) forhindrer en omdirigeret gendannelse på grund af det manglende TDE-certifikat. 

Resolution

Hvis du vil kontrollere, at TDE er aktiveret på en SQL-database, skal du forespørge databasen ved hjælp af SQL-kommandoprompten.
  • Hvis TDE er aktiveret, så "is_encrypted" er "1"
 
For at løse dette problem skal certifikatet anvendes manuelt på SQL-forekomsten, før gendannelsen påbegyndes. 
  • Kontakt Microsoft for at få hjælp.

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.