• IMHO, the backup will happen regardless of whether or not the CATCH block is executed (i.e. regardless of DBCC raising an error).

    That is because the BACKUP command comes AFTER the END CATCH ....

    What is the purpose of the TRY/CATCH block if not to avoid crashing an execution sequence?