Hello, world.
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 party tools ?
A:
No.
Backup encryption is not supported out of the box, even in SQL Server 2008.
Redgate's SQL Backup supports it.
Mitch Wheat
2010-03-28 14:47:18
A:
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
gbn
2010-03-28 17:26:32