question

AviGrinberg-1893 avatar image
0 Votes"
AviGrinberg-1893 asked Cathyji-msft answered

always backup database with encryption

Hi,

is there a way to force that all backup database and backup log that runs on the server will be enforced with the encryption(if not specifying the encryption the query will be terminated )?

THX

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @AviGrinberg-1893,

There is no option to force backup databases and logs with encryption.

If you want data in backups encrypted, you can enable Transparent Data Encryption (TDE) on your database. When a database is encrypted with TDE, the backups contain the encrypted data.

Quote from the MS document.

Backup files for databases that have TDE enabled are also encrypted with the database encryption key. As a result, when you restore these backups, the certificate that protects the database encryption key must be available. Therefore, in addition to backing up the database, make sure to maintain backups of the server certificates. Data loss results if the certificates are no longer available.


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.