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.

Our old DB admin is gone, any ideas?

It looks it was set up many years ago.

share|improve this question

migrated from serverfault.com Jan 2 '13 at 18:48

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

    
Did the DB admin leave any documentation behind? –  Hennes Jan 2 '13 at 18:36
1  
Two things: 1) go accept some of your old questions, your accept rate is pretty low. 2) what master key are you looking for? –  Brent Pabst Jan 2 '13 at 18:39
    
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
add comment

1 Answer

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.

ALTER MASTER KEY 
FORCE REGENERATE WITH ENCRYPTION BY PASSWORD = 'YourNewPassword!';
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
add comment

Your Answer

 
discard

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.