Backup With Password

SQL Server Administration
1

hi, i have a sql server 2012 database.
i have created a maintenance plan including FULL BACKUP.
is it possible to create backup file with password?
i search on google and find some script like this:

BACKUP DATABASE Northwind TO DISK='C:\Northwind.BAK' WITH MEDIAPASSWORD='mssqltips'

But is it possible on a maintenance plan?

regards.

2

From the documentation here:

Beginning with SQL Server 2012 the PASSWORD and MEDIAPASSWORD options are discontinued for creating backups. It is still possible to restore backups created with passwords.

3

so, it's not possible to do this with maintenance plan? am i right?

regards?

4

if you enable TDE on your database then the backups will also be encrypted.

5

By using TDE in your database allow you to set database to use encryption. See here