SQL Backup Master offers the ability to execute a custom batch (.bat) script before and after the associated backup job is executed.
Error and informational messages that occur during custom batch script execution are written to the SQL Backup Master log. Such errors will not halt the progress of the backup job.
SQL Backup Master makes backup job state information available to your batch script at run time by setting environmental variables for the script process.
The following environmental variables are defined:
•SQL_BACKUP_MASTER_TYPE - "Full", "Diff" or "Log"
•SQL_BACKUP_MASTER_STAGE - "BeforeBackup" or "AfterBackup"
•SQL_BACKUP_MASTER_STATUS - "Finished", "FinishedWithErrors", "Cancelled" or "Failed"
Here's a simple custom batch script example:
Note that the SQL_BACKUP_MASTER_STATUS environmental variable will only be available if the SQL_BACKUP_MASTER_STAGE variable is "AfterBackup".
If your custom batch script produces an error or returns an exit code other than zero (0), an error will be logged by SQL Backup Master and will be reflected in the final backup job state. Such errors will not halt the overall backup job.
If your batch script needs to return an error state, it should use the EXIT statement with a code other than zero (0).
If your batch script outputs messages via the ECHO statement, they will be logged as information messages in the SQL Backup Master log.