January 12, 2005 at 3:18 am
I'm thinking about password protecting my backups as another level of security.
However, I know I can script a restore but has anyone figured out how to restore with EM when the backup has a password on it?
Thanks,
January 12, 2005 at 6:59 am
Hadn't noticed before but looks like wizard doesn't support dealing with the password.
January 13, 2005 at 10:08 am
EM does'nt support Restore with Password
January 14, 2005 at 7:34 pm
One option is to buy the Professional version of SQL LiteSpeed to do your backups. You can do password protected and encrypted backups. The backups also are compressed.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
January 15, 2005 at 9:43 pm
LiteSpeed also has their own enterprise management console that allows easy restores of protected backup files.
One thing to keep in mind with native password protected backups. Even though the backup is password protected, the data is still plain text. You can open up a password protected backup file in notepad or any hex editor and actually change data. When the backup file is restored, the altered data will be restored as well.
With LiteSpeed encrypted backups, not only do you need the encryption key to restore the backup file but the data within the file is encrypted as well.
February 13, 2006 at 12:16 pm
Yes that is true. Go download Hexedit off of download.com, alter a backup file, and then restore the backup file. It works very well with char fields. Simply Find a name, change it to a name with the same number of characters in it and when you restore the database the changes will propegate into the database.
Scary thought.
I'm not sure why the password protection features is going away. My only thought is that no one used it so why bother supporting it?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply