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.
- Create a master key
- Create certificate
- Backup database
- 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.