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

SEARCH BY TAGS: 

Please reload

RECENT POSTS: 

FOLLOW ME:

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

Backup Encryption

February 26, 2018

 

 

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

 

 

 

 

Share on Facebook
Share on Twitter
Please reload