always backup database with encryption

Avi Grinberg 21 Reputation points


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 )?


SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,070 questions
0 comments No comments
{count} votes

Accepted answer
  1. CathyJi-MSFT 21,111 Reputation points Microsoft Vendor

    Hi @Avi Grinberg ,

    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.

    0 comments No comments

0 additional answers

Sort by: Most helpful