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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Our old DB admin is gone, any ideas?

It looks it was set up many years ago.

share|improve this question

migrated from Jan 2 '13 at 18:48

This question came from our site for system and network administrators.

Did the DB admin leave any documentation behind? – Hennes Jan 2 '13 at 18:36
Are you referring to the server master key or the database master key? Why are you trying to reset it? – mrdenny Jan 2 '13 at 18:48
no documentation, trying to reset it as we are setting up a mirror server now our db admin is trying to copy over the existing db. – Alex Jan 2 '13 at 18:52
Find your old questions and which ever answer is correct, check the check mark next to that answer. – mrdenny Jan 2 '13 at 19:02
up vote 1 down vote accepted

Assuming that you are trying to reset the database master key you just need to use the ALTER MASTER KEY statement adding in the keyword FORCE.

share|improve this answer
are you able to encrypt specific tables? such as just credit card data for PCI Compliance purposes? – Alex Jan 2 '13 at 19:23
Sure, but not by just setting the database master key. That requires changing the code which is storing and reading the data so that it is encrypted and decrypted as needed. That's a much bigger job. – mrdenny Jan 2 '13 at 19:27

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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