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) }

Everything to Know About Cloud VDI and Azure Virtual Desktop

By now, most of us have experienced some form of remote work, whether it was during the height of the pandemic or now in the midst of the hybrid work...

What's New in SQL Server 2022 – Licensing Updates

SQL Server 2022 is now generally available and with it come some licensing changes you need to be aware of. Microsoft also announced that SQL Server...

Azure Modernization Assessment: Building a Robust Cloud-Ecosystem Starts Here

The pandemic may have accelerated the cloud journey trend, but cloud momentum isn’t slowing down anytime soon. Cloud adoption increased 25% in the...