Technical Article

Remove Database Encryption Key on all user databases

Below script will remove database encryption key, database certificate and master key on all the user databases.

For tempdb database, you need to restart the SQL Server Instance to complete the process.

Note: It is advisable to take transaction log backup before this activity is performed.

4 (1)

2018-02-08 (first published: )

1,651 reads

Blogs

Speaking at SQLSaturday MN 2022

By

Thanks all for joining me for two sessions at SQLSaturday Minnesota 2023, and for...

Goal Progress for Nov 2022

By

I set goals at the beginning of the year, and I’m tracking my progress...

PGSQL PHRIDAY #3: What is the PostgreSQL Community To You?

By

Very excited to take part in my third #PGSQLPhriday blogging event, even more so...

Read the latest Blogs

Forums

Windows login Token-based server access validation failed with an infrastructure

By Raja mssql

Hi All, One of our windows login is not working which is been configured...

Subtract calculated columns

By pedroccamara

Hello all I am sorry to bother but I really can't find the solution...

Help Parsing String

By Tav29

I can do the Last Name, First Name; my problem is Middle Initial. I...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers