When encrypting large database > 10TB . I had to issue --alter database set encryption on several times , but the encryption starts and fails with the same message in the error log. where can i find why the encryption scan failed ?
Error Log entry
Database encryption scan for database was aborted. Reissue ALTER DB to resume the scan. This is message in the sql server error log.
The Database compatibility level is
To be clear when I run the
alter db <dbname> set encryption on command the encryption starts progresses by small percent and fails immediately. currently it is at
0.4716863 percent . when it fails it fails with
encryption_state = 2 and percent_complete=0
SQL Server version
Microsoft SQL Server 2016 (SP2-CU7-GDR) (KB4505222) - 13.0.5366.0 (X64) Jun 15 2019 08:22:25 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: )