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.
| Author |
Topic |
|
xpandre
Posting Yak Master
212 Posts |
 Posted - 2011-05-13 : 11:02:18
|
| We accidently deleted our TDE certificate from the master DB and we had 5 DB's encrypted with that certificate.Now we dont have the password:(Is there any way we can get the encryption OFF for the 5 DB'S..right now its in a no-state.. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-05-13 : 11:12:31
|
Do you mean you have enabled TDE for 5 databases and you have not taken a backup of the certificate created?Then good luck  Not sure if someone knows a way...
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
xpandre
Posting Yak Master
212 Posts |
Posted - 2011-05-13 : 11:26:45
|
| I have the backup of my certificate, but we dont remember the password we used:( |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-05-13 : 11:33:16
|
| You need the password and the certificate. If you don't have both, those databases and any encrypted backups are lost beyond recovery.--Gail ShawSQL Server MVP |
|
|
|
xpandre
Posting Yak Master
212 Posts |
Posted - 2011-05-13 : 11:42:08
|
| thank you sir:-( |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-05-13 : 11:50:43
|
| Oh, and any database backups taken since TDE was enabled are also useless as they cannot be restored without the certificate.--Gail ShawSQL Server MVP |
|
|
|
sarabpreet12
Starting Member
5 Posts |
Posted - 2011-05-16 : 11:48:27
|
| Do you have Backup of Master Database after you configured TDE? If yes, then restore Master on some other instance to make it work & you can also export the cert again and import here.You can also replace Master on the same instance if you're sure there were no Logins created after that or there were no server level changes.This should help you... otherwise, Contact Microsoft.Sarabpreet Singh |
|
|
|
|
|
|
TDE...