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

 

MailStore Software GmbH

Clörather Str. 1-3

41748 Viersen, Germany

 

Phone:   +49-2162-50299 0

Fax:     +49-2162-50299 29

E-mail:  ralf.jansen@...

Web:     http://www.mailstore.com

 

Handelsregister Mönchengladbach, HRB 11557

Geschäftsführer: Philip Weber, Anthony Folger, Thomas Kasper