SQL Backup Master offers the ability to execute a custom SQL script (e.g. a set of custom SQL statements) before and after the associated backup job is executed.
If an error occurs during the execution of a custom SQL script, a warning is logged to the SQL Backup Master log file. The log file entry will include additional information about the nature of the problem (e.g. syntax errors, etc.). Such errors will not halt the progress of the backup job.
oUse the "GO" statement to separate logical blocks of T-SQL code.
oThe "USE" T-SQL command should be used to switch between databases during script execution, followed by a "GO" statement.
oUse SQL Server Management Studio to write and debug your scripts prior to using them within SQL Backup Master.