October 14, 2016 at 1:46 pm
I need a script that will turn off encryption and once the database is decrypted drop the key and certificate. Currently when I turn off encryption on a 140 GB database it takes a while to decrypt and then I can drop the cert and key. I am trying to automate it and need a script that will drop the cert and key when the database is decrypted.
December 15, 2016 at 2:58 am
When the data is written from buffer pool to disk (MDF, LDF & NDF) the data is first encrypted and then then encrypted data will be sent to disk.
Regards,
best essay writing service
December 16, 2016 at 1:46 am
The script is
set encryption off
go
DROP DATABASE ENCRYPTION KEY
go
use master
go
drop certificate mycert
You'll need to change the names to match your db and cert.
January 29, 2018 at 12:23 am
This was removed by the editor as SPAM
October 29, 2019 at 7:33 pm
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply