SQLTeam.com | Weblogs | Forums

Backup With Password

sql2012

#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