November 7, 2007 at 1:57 pm
If you encrypt some data using a symmetric key with a password. It appears
that the database master key is not used at all to encrypt the data. Is this
true? Also it appears you can backup the database and move it to another
server, and retrain the password for the symmetric key from the old server.
Meaning that after you restore the database to a new server you can use the
symmetric key password from the old server to open the symmetric key in the
database on the new server and decrypt the data.
My basic question if you create a symmetric key with a password, and encrypt
data with that symmetric key, then is there any reason you would need to
create a master key for the database?
Gregory A. Larsen, MVP
December 2, 2007 at 1:05 pm
Are you using a passphrase or encryption by password?
The database master key should exist with the database. If anything, when you restored, you'd need this to continue to the restore.
The password encryption, AFAIK, doesn't need the DMK.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply