Search code examples
sqlsql-serverencryptionsql-server-2008-r2tde

SQL Server 2008 R2 tde stop encryption process


I have a rather larger database I will be encrypting using TDE. I have a defined window to complete the encryption. I need a way to stop the encryption process if the time window is exceeded.

Thanks


Solution

  • Microsoft says it is not possible to stop the TDE encryption once it has been started because it creates an exclusive lock on the database.