As automssqlbackup works fine on the machines that I installed it, there’s always opportunity to fine-tune. This time it’s the notification emails being sent.
I modified the PowerShell script to send HTML emails.
The first part of the email contains a table with the list of selected databases, the status (“OK” or message of an exception), the name of the generated file or archive, and the sizes of the .bak and .zip files.
The second part contains the script’s transcript (i.e. the original mail contents).
automssqlbackup is available for download here.