New version of sp_BackupDatabases released this morning, first update that I’ve made available in a while. I’ve been running this version myself for months, so it’s well-tested, I just forgot to post the update here.
Changes in this version:
– Include brackets around database name in all commands, in case someone uses a reserved word, or a space, or something equally stupid in a database name
– Add parameter @output_log_directory parameter to define location of job output logs. If not specified, will use default SQL log directory
– Sub-jobs now inherit notification properties of parent job
– Expand “frequency” parameters to 4 characters to allow for larger hourly intervals, e.g. “168H”
– Add “fail-safe” schedule to each sub-job to run on SQL startup, to prevent “stuck” jobs resulting from a server restart
Grab this latest version, or any of the previous versions, from the sp_BackupDatabases download page: http://realsqlguy.com/downloads/sp_backupdatabases
