June 18, 2012 at 1:53 pm
Quick one.
If I inherit an encrypted db in 2008. I have the cert and password how do I transfer this to the TEST environment to restore my live db.
June 18, 2012 at 2:30 pm
You need to backup http://msdn2.microsoft.com/en-us/library/ms174387.aspx
and then restore your master key http://msdn2.microsoft.com/en-us/library/ms186336.aspx
June 20, 2012 at 7:44 am
The master key has absolutely nothing to do with moving the database!
You need a backup of the certificate and its password and the database backup itself. The master key merely protects the certificate while it's installed on the SQL Server instance. A master key must be created on the target instance if it hasn't already but it's in no way tied to the source server!!
For more info on moving a TDE protected database see this Microsoft KB
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply