December 27, 2016 at 11:23 am
Hello all,
How to recover a database if an encryption key is lost?
Thanks.
December 27, 2016 at 9:55 pm
This was removed by the editor as SPAM
January 4, 2017 at 6:07 am
ichervin (12/27/2016)
Hello all,How to recover a database if an encryption key is lost?
Thanks.
It's not clear what your issue is here.
Have taken an encrypted backup in sql server 2014 and now need to restore this backup?
JasonClark (12/27/2016)
USE AdventureWorks2008R2;ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD = 'dsjdkflJ435907NnmM#sX003';
GO
With this, you can regenerate the encryption key.
That only alters the master key encryption password
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2017 at 6:46 am
ichervin (12/27/2016)
How to recover a database if an encryption key is lost?
UR;LT
Seriously, what is your exact situation?
TDE database with no certificate backup, but database still open and usable?
TDE backup, no certificate, no database?
Encrypted database backup with no key?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 4, 2017 at 9:16 am
GilaMonster (1/4/2017)
Seriously, what is your exact situation?
Million dollar question 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2017 at 10:35 pm
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply