Windows 10: Fix: Cannot find server certificate with thumbprint while restoring SQL database

When restoring a database you might get the below error.

System.Data.SqlClient.SQLError: Cannot find server certificate with thumbprint



This is because the database was encrypted with Transparent Data Encryption (TDE) and you will not be able to restore it until you get the Certificate, the Private key and the password from the supplier of the database.

After you collect the required items above, open a new SQL query as the server admin on the database master.

First we need to create the master cerificate on the server by using

USE master
GO
CREATE MASTER KEY ENCRYPTION BY PASSWORD = '<MyComplexPassword>'
GO

Now that the master certificate has been installed you will need to install the certificate provided by the owner of the database

CREATE CERTIFICATE MyServerCert
FROM FILE = 'C:\TDECert\Cert.cer'
WITH PRIVATE KEY (FILE = 'C:\TDECert\key.pvk',
DECRYPTION BY PASSWORD = '<PasswordProvidedByTheSupplier>');

Once this is done and executed you will be allowed to restore the database.

(0)

read more...

 

Running sql server 2005 and have restored several databases from backups using commands

Original Title: sql server 2005

I have a windows 10 computer running SQL server 2005 and have restored several databases from backups that were created using the following command:

BACKUP DATABASE @name TO DISK = @fileName WITH INIT

After restoring those databases, everything seems to run fine, but sys.dm_db_index_usage_stats is not being updated effectively. I can only get the stats to show up for 1 database at a time, and it only seems to be temporary. They are removed as soon as
the next database is updated. The last updated database will only stay there temporarily too. I am not detaching the databases or restarting the server or doing anything else that should reset the statistics. Any ideas?

 

SQL Server Files

Hi RalphHead,

Sorry for the inconvenience caused to you and thank you for your valuable question please, Before attempting reload of Windows 10 I would suggest you to please see the below mentioned article and see if it helps, If the issue persists kindly let me know,waiting
for your kind reply please.

https://docs.microsoft.com/en-us/sql/relational...

Please let me know, if that helps and feel free to ask back any question.

Kind Regards:

Yasir

 

Always Encrypted now generally available in Azure SQL Database

Source: Always Encrypted now generally available in Azure SQL Database | Blog | Microsoft Azure