Morning. Have a quick question. We are trying to restore a database with an old DMK password and it is failing. When running Select * from sys.symmetric_keys I do see the "Modify_Date" different from the "Create_Date" (year difference) which tells me someone blew up our original DMK.
So question is, if we create a new DMK password, will this mean that all the data that is currently encrypted using the original DMK will be unreadable (my guess is yes).
Thanks...and hopefully this makes sense...haven't had any caffeine today. 🙂