Viewing 3 posts - 1 through 4 (of 4 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...
Donald
March 31, 2016 at 11:30 am
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...
Donald
August 15, 2011 at 9:40 am
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...
Donald
March 7, 2008 at 8:22 am
Viewing 3 posts - 1 through 4 (of 4 total)