<div>
Is it TDE encrypted database? In this case you have to copy the cretificate and private master key to destination server. Which you use while enabling Transparent data encryption.
</div>


Is it TDE encrypted database? In this case you have to copy the cretificate and private master key to destination server. Which you use while enabling Transparent data encryption.

<div>
yes, TDE encrypted database.<br />
<br />
but if you have to restore it to the same server, is this an issue?<br />
<br />
but the thumbprint referenced is not in sys.certificates?
</div>


yes, TDE encrypted database.

but if you have to restore it to the same server, is this an issue?

but the thumbprint referenced is not in sys.certificates?

<div>
<div class="content wysiwyg-content">
When trying to do a restore, it fails this way:<br />
~~~<br />
Cannot find server certificate with thumbprint 'bigUIDnumber'.. <br />
~~~<br />
But when I do a select * from sys.certificates, I don't see any thumbprint that matches it.<br />
<br />
What could be the thumbprint that is being referenced in the failure message?
</div>
</div>


When trying to do a restore, it fails this way:
~~~
Cannot find server certificate with thumbprint 'bigUIDnumber'.. 
~~~
But when I do a select * from sys.certificates, I don't see any thumbprint that matches it.

What could be the thumbprint that is being referenced in the failure message?

thumbprint referenced in RESTORE FAILURE (SQL 2012)

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.