Find out the last full backup date for a database
2009-06-24 5 Comments
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) }
Pingback: E2K7: Determining Status of Database Backups : Servus
Pingback: E2K7: Determining Status of Database Backups : Servus
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.
Oh I forgot to say thanks :-)
My pleasure, thanks for reading and the feedback!