However, if your goal is to migrate the encryption from your system to the production system and it is working on your system, then you need to back up the Database Master Key to a file and restore it to the production database. You also said you don't care about the encrypted data since it is test data. I suspect you are asking the wrong question because the answer to "how can I return the database back to the point where is has no keys?" is to drop all of the keys. Doesn't seem to work, can't remember exact error. ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD ![]()
0 Comments
Leave a Reply. |