How to Enable, Suspend, and Resume TDE Encryption Scans in SQL Server Always On

 

Transparent Data Encryption (TDE) is a crucial security feature in SQL Server that protects data at rest by encrypting database files. In an Always On availability group, managing TDE encryption scans efficiently is essential to ensure minimal performance impact and seamless data protection. This guide will walk you through the process of enabling, suspending, and resuming TDE encryption scans in SQL Server Always On, helping you maintain security while optimizing system performance. Whether you need to temporarily pause encryption scans for maintenance or resume them after an interruption, these steps will ensure smooth database operations.

For encrypting an SQL Server database, please review Encrypt an Existing MS SQL Server 2019 Database in an Always On Environment Using TDE

How to Decrypt a TDE-Enabled Database in a SQL Server Always On Environment

 

There could be various reasons for removing an existing TDE (Transparent Data Encryption) implementation from SQL Server databases. You may be considering an alternative encryption solution, experiencing performance issues, or needing to share a copy of the database or its backup with other business units that do not support TDE. Regardless of the reason, properly decrypting a TDE-enabled database in a SQL Server Always On environment requires careful execution to ensure data integrity and minimize downtime. In this guide, we will walk through the steps to safely remove TDE encryption from a database while maintaining availability and security.

For encrypting an SQL Server database, please review Encrypt an Existing MS SQL Server 2019 Database in an Always On Environment Using TDE

Configuring a Second Listener on EXACC ASM Cluster to fix Cluster ASM monitoring Issues in Oracle OEM

1. Introducing the Issue

Recently, we encountered an issue in our OEM while trying to monitor the EXACC ASM Cluster. This is my EXACC cluster configuration in OCI.

The OEM displayed the cluster status as down, despite all configurations being correct. The error was as follows: 

"failed to connect: java.sql.sqlrecoverableexception: listener refused the connection with the following error: ora-12514, tns:listener does not currently know of service requested in connect descriptor"