I just learned that enabling encryption via “ALTER DATABASE ENCRYPT etc.” starts encryption of the database asynchronously in the background.

Are there any settings or something to change/manage the behavior or monitor the progress?

 

For example, I would need to be able to start stop that background encryption for backups (via volume shadow service).

Normally I could simply stop all running connections and clearing the connection pool to get the database into a state where it could be backed-up.

But the encryption task seems to keep a handle to the file open.

 

 

--

Mit freundlichen Grüßen / Kind regards

Ralf Jansen

Hi,

 

how often do you encrypt database? i suppose that only once.

but i agree that will be good to see possibility to check finished state

 

P.S.

this is not good think to include database file in Volume Shadow Copy Service

better is to remove database file and include only backup file after its creation.

 

regards,

Karol Bieniaszewski