Viewing 3 posts - 1 through 3 (of 3 total)
When I restore a database with encryption to a different server, I have to reencrypt the DB Master Key using the Server Key.
I use this script:
Use <DATABASENAME>
OPEN MASTER KEY DECRYPTION...
March 31, 2016 at 11:30 am
#1868966
Just a question/comment:
If you backup an SMK from one physical server and restore it to another you do indeed fix a particular DMK issue.
But if there are other databases that...
August 15, 2011 at 9:40 am
#1368692
The situation described is our production architecture. We deal with this issue on an ongoing basis and have had various successes and failures.
The issue, as we have defined and observed...
March 7, 2008 at 8:22 am
#786709