Activity overview
Latest activity by warnerra
Encrypting Passwords in stored procedures manually scripted
Hello,
As a security measure, is it possible to cause the password used for encryption to be encrypted within a stored procedure that is created outside the wizard?
I realize this happens for jobs ...
Brian,
Thanks for the reply.
Yes, I understand there is no easy way to do this as I have played with different approaches. I see pros and cons no matter which way I go. Having even a simple requirement to update the notification email address can have large implications if I make it a single job with multiple calls to the stored procedure. I have a template worked out, so it's not too tedious.
I have one additional question. Because I am making the backup file available for download via https to my customers, I must contend with the file extension type or else convert the file to a type that is acceptable, such as a zip type. Does any approach lend itself for a final step to zip the backup COPYTO file?
Thanks again,
Rick / comments
Brian,
Thanks for the reply.
Yes, I understand there is no easy way to do this as I have played with different approaches. I see pros and cons no matter which way I go. Having even a simple requi...
Batch Job Creation
Hello!
I have just purchased SQL Backup 4.6 and I must create 3 jobs each for 200 databases (weekly FULL, nightly DIFF and daytime incrmntal LOGs every 2 hours).
Each database goes to a different e...