Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I want to add multiple master database encryption keys and certificates.

Can I do that?

share|improve this question
    
why do you want multiple versions ? –  DamagedGoods May 21 '13 at 10:22
add comment

closed as not constructive by marc_s, Marian, Mark Storey-Smith, Jon Seigel, RolandoMySQLDBA May 21 '13 at 16:28

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer

From my knowledge, you cannot have multiple encryption database encryption keys as the Server stores a Server Master key automatically when SQL Server is first installed. It will use this for decryption (among other things) of database keys.

When you have created a database key (which is implicit) it will store a copy in the Master db, if you issue another create statement that will replace the existing key.

You should be creating a backup of the DMK and storing this somewhere secure, there is nothing to stop you having multiple copies of this key backup.

MSDN should tell you everything you need to know in greater detail.

http://technet.microsoft.com/en-us/library/bb964742.aspx

you will be able to create multiple certificates for external software etc. you can generate these keys yourself or get them from external providers

http://msdn.microsoft.com/en-us/library/ms187798.aspx

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.