Share via

encrypt backup files.

Heisenberg 261 Reputation points
2024-03-05T21:12:24.33+00:00

hi folks,

Currently we are using 3rd party vendor (Netlib) encryption software to backup our data files and database backup files. The way this works is we encrypt sql instance and data /tran. log files using an encryption key (64 bit) with AEC algorithm which also automatically encrypts our backup files when backup happens. if someone wants to decrypt the backup files it needs the netlib software and the decryption key. Without which the backup file is useless.

Is there a similar functionality available in TDE or any other software. Basically we want to encrypt at least our backups when they happens automatically. I am not concerned about mdf or ldf file encryption.

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,673 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 110.3K Reputation points
    2024-03-05T22:26:43.1366667+00:00

    Look at the topic for BACKUP, https://learn.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?view=sql-server-ver16 and search for ENCRYPTION. I have never tried this option myself.

    0 comments
  2. ZoeHui-MSFT 36,116 Reputation points
    2024-03-06T02:49:29.85+00:00

    Hi @Heisenberg,

    This article provides an overview of the encryption options for SQL Server backups. It includes details of the usage, benefits, and recommended practices for encrypting during backup.

    Backup encryption

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments
  3. Heisenberg 261 Reputation points
    2024-03-06T15:07:38.93+00:00

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.