Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Restore Master DB Certificate

Author  Topic 

mody1983
Starting Member

2 Posts

Posted - 2011-01-18 : 08:33:37
Hi,

I was studying the TDE, I found that the data base encryption key can be protected by a server certificate...

so, the key for protecting the TDE encryption is the certificate ... now I've succeeded in backing up the certificate using the command:

Backup certificate myAchCert
to file='C:\CertBackupAch2.txt'
with private key( decryption by password='stpLE@sE!',
file='C:\CertPrivateKeyAch2.txt', encryption by password='cert ach pass');


Now, I want to restore my backed up certificate, and I want to validate that the user restoring the certificate from the backup file is having the correct password ... please help
   

- Advertisement -