We love Ola Hallengren’s Maintenance Solution but you should always always double-check either the msdb backup history or the
master.dbo.CommandLogtable to make sure any important backup was taken. This is especially important if you trigger it manually and are relying on human input to get the parameters right.
Here are three easy to miss cases where the scripts won’t backup a database. These absolutely, definitely, aren’t bugs, they’re idiosyncrasies with the underlying backup command and (sometimes) how the script works. But they’re also much easier to miss in the verbose output of the script.
The moral of the story is to check your automated backup routines and make sure that they are doing what you expect.