One solution is to use a single central maintenance and monitor database that is then added to an Availability...

Hi Joe,

Thanks for the script.

Note that it does not cover Availability Group database backups.

Ola Hallengren's maintenance solution places these backups in a separate folder for each Availability Group.

Regards,

DBA Pete.

Thanks vikingDBA for sharing this great script.

I made one minor change as it was missing square brackets around the database name under the section "Finding orphaned database users"

So

SET @SQL =...

Hi Karl,

That works.

I also could not find a better way than to use an additional union to get this information.

If anyone does come up with a better way then let...

Hi Jon,

This is what I mean:

Create a new database called TEST in full recovery mode. It has never been backed up and shows as:

DatabaseName recovery_model ...

That is a great script Karl Klingler, very compact compared to the original script, but I notice both the original script and your script does not report on the important...