Sql server backup with password

When we backup data in SQL server, i want a way to password protect it. Is there a way to do this without using third par开发者_如何学JAVAty tools ?

No.

Backup encryption is not supported out of the box, even in SQL Server 2008.

Redgate's SQL Backup supports it.

Until the next version, you have a basic password option for BACKUP DATABASE. However...

The protection provided by this password is weak. It is intended to prevent an incorrect restore using SQL Server tools by authorized or unauthorized users. It does not prevent the reading of the backup data by other means or the replacement of the password.

...so it's not very good, so use the 3rd party tools from Red Gate or Quest