Here’s the powershell code to query that last backup info for all the DBs on a server. Dir | FT Name, LastBackupDate, LastLogBackupDate, LastDifferentialBackupDate That’s it.

Note that you do have to run a PowerShell script that uses VSS-based backup and recovery, robocopy (a tool introduced in the Windows 2000 Resource Kit), PowerShell scripting (logically), and some ...