Password Management
michaelfried
Posts: 25
Dear SQL Backup Community,
What is the best way that people are handling password management when creating encrypted backups.
I am using SQL Backup Pro v 5.3. I have a set of scripted out stored procedures that call the extended sql backup stored procedures. I am using encryption and so need a password. As I see it I have these choices:
1) Hard-Code the Password in my custom stored procedure
2) Make the Password a parameter in my stored procedure and pass it in -- which means I need to hard-code the the Password in the SQL Agent Job Step details
3) Store the Password in a table and lookup that value in my stored procedure
How are other people handling this? Is there a recommended way?
Mike
What is the best way that people are handling password management when creating encrypted backups.
I am using SQL Backup Pro v 5.3. I have a set of scripted out stored procedures that call the extended sql backup stored procedures. I am using encryption and so need a password. As I see it I have these choices:
1) Hard-Code the Password in my custom stored procedure
2) Make the Password a parameter in my stored procedure and pass it in -- which means I need to hard-code the the Password in the SQL Agent Job Step details
3) Store the Password in a table and lookup that value in my stored procedure
How are other people handling this? Is there a recommended way?
Mike
Comments
To get the encrypted value for your password, start up the Backup Wizard in the GUI, and enter the parameters for your backup. On the 'Review backup summary' page, open the 'Script' tab. In the script area, you see the backup script containing the encrypted password. Use this value instead of your plain-text value.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8