data-konzept

'Let’s work through some code to do an encrypted backup. This feature is available to you if you are using SQL Server 2014 onwards but I decided to use SQL Server 2017.

To encrypt during backup, you must specify an encryption algorithm, and an “encryptor” to secure the encryption key. I have decided to use the following options:

• Encryption Algorithm: AES 256

• Encryptor: A certificate

First step is to create a certificate.'...

http://www.sqlservercentral.com/blogs/all-about-sql/2017/10/09/sql-server-2017-encrypted-backups-and-compression/?utm_source=SSC&utm_medium=pubemail