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