No tags yet.

SEARCH BY TAGS: 

RECENT POSTS: 

FOLLOW ME:

  • Facebook - Black Circle
  • Twitter - Black Circle
  • Instagram - Black Circle
  • LinkedIn - Black Circle

Backup Encryption


If you're storing any of your database backups off site or in the cloud, you might want to look into encrypting your backups. This feature was first introduced in SQL 2014.

Since we're working with encryption on SQL server the first step is to create a Database Master key.

Then we create a certificate.

Then run your backups with the correct syntax and specify the algorithm you'd like to use (AES 256,128, 192 or Triple_DES_3Key).

#sqlserver #backups #DBA #Encryption