Find out the last full backup date for a database

I was going mad last night trying to find out the time for the Last Backup of a database. After a while I found out that I needed to add -status to my 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) }

5 Responses to Find out the last full backup date for a database

  1. Pingback: E2K7: Determining Status of Database Backups : Servus

  2. Pingback: E2K7: Determining Status of Database Backups : Servus

  3. patk7 says:

    I was pulling my hair out over this one. I don’t understand why one must specify that switch in order to get such basic information.

    Sometimes I don’t understand Microsoft. Okay, often.

  4. patk7 says:

    Oh I forgot to say thanks :-)

Leave a comment