E2K7: Determining Status of Database Backups

While running some reports on Exchange backup success I could not figure out why when I ran get-mailboxdatabase | fl Name,LastFullBackup it would return a blank LastFull Backup.  In Exchange Management console I could look at the properties of the database and see the Last full backup and the Last incrementation backup times.

After some search, Martin’s Wonderful World of Exchange had an answer for me.  You need to add -status to your command or the backup properties where blank.

Command as follows:

Get-MailboxDatabase -Status | fl Name,Server,*backup*

If you only want the LastFullBackup:

Get-MailboxDatabase -Status | fl Name,Server,LastFullBackup

And if you only want to list the databases where the backup didn’t go as planned today:

Get-MailboxDatabase -Status | Select Name,Server,LastFullBackup | Where { $_.LastFullBackup -le (get-date).adddays(-1) }