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.