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

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 Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: