In this article, we will learn to take the backup of MS SQL database with password protected. Password protected files are very secured since unauthorized person will not able to access it. If it is database then it is more important to secured the database backup file with password.
Process is very simple and any one can use it easily, just need to follow few steps.
However, you can't perform this action from wizard, you can perform this action only via SQL.
SQL Query to protect the backup file with password:
backup database Northwind
to disk = 'd:\test\northwind.bak'
with password = 'password'
Only 3 lines of code and your backup file is protected with password :-).