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

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.