October 7, 2003 at 3:34 am
Hi I would like to know if it is possible to password protect the backup process in SQL Server 2000. Can I ensure that a password is always asked for before a backup or a restore of a database can take place? If so how do you go about doing this? Thank you
October 7, 2003 at 7:23 am
Use PASSWORD parameter to set the password for the backup set. PASSWORD is a character string. If a password is defined for the backup set, the password must be supplied to perform any restore operation from the backup set.
Check Backup command in BOL for details.
October 7, 2003 at 7:25 am
You can always ensure a password is asked for on a restore if the backup has been password protected. However, there is no way to force the password on the backup itself. Also, there is a lot of information that is clearly readible in a backup file, even with a password. The password just stops a SQL Server restore... I don't believe it was intended to encrypt the contents.
The only product that comes to mind that'll do what you want is SQLLiteSpeed. Click on one of the ads or go here:
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
October 8, 2003 at 9:01 am
Stormy1,
Brian Kelley’s posting is correct. SQL LiteSpeed (www.dbassociatesit.com) has 128 bit encryption capabilities at the backup level that will protect your back on disk and tape. The encryption capabilities have become very important for companies in the US that need to protect backups for auditing and compliance purposes such as HIPAA, SOX, SAS 70, etc. I have a written a few articles on the SQL LiteSpeed that you can find at - http://www.edgewoodsolutions.com/partners/dbassociates.asp. You can also download an evaluation copy at - http://www.edgewoodsolutions.com/litespeedeval.asp to check out the product yourself for 15 days. Besides the encryption capabilities, the inherent compression capabilities can reduce your backup size up to 90% and save an inordinate amount of disk space.
Let me know if this is helpful and feel free to send me an email at jeremyk@edgewoodsolutions.com if you have some additional questions.
Thank you,
Jeremy Kadlec
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply