DBA - How To Disable Transparent Data Encryption (TDE) On SQL Server Database

To disable Transparent Data Encryption (TDE) on SQL Server database, below code can be used.

USE MASTER
GO
ALTER DATABASE DatabaseName
SET ENCRYPTION OFF
GO
USE DatabaseName
GO
DROP DATABASE ENCRYPTION KEY
GO