0

Our old DB admin is gone, any ideas?

It looks it was set up many years ago.

  • 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
1

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.

ALTER MASTER KEY 
FORCE REGENERATE WITH ENCRYPTION BY PASSWORD = 'YourNewPassword!';
|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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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