Menu Close

Taking Encrypted Backup in SQL Server

In this post, I will explain how to take encrypted backup in SQL server using T-SQL and SQL Server Management Studio (SSMS). Encrypting the database backups help to secure the data and a primary demand for cloud solutions. SQL server 2014 first introduced the new feature to encrypt backups natively. So without further ado, let jump into that.

From T-SQL

  • Create a master key

 
  • Create certificate

  • Backup database

 
From SSMS
 
  • Right click on database whose backup is required ==> Tasks ==> Back Up…

  • Click on ‘Media Option’, choose backup to new media and name the media set
  • Now go to ‘Backup Option’, check Encrypt backup, and choose Algorithm and Certificate.

  • Finally, click OK at the bottom and done, you will get a popup once completed. 

 

~thankyou for reading

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *