Reporting on database backup status
Using the Exchange Management Shell, we can write scripts that will check on the last full backup time for a database that can be used for monitoring and reporting. In this recipe, you will learn how to check the last backup time for each database and use this information to generate statistics and find databases that are not being backed up on a regular basis.
How to do it...
To check the last full backup time for a database, use the Get-MailboxDatabase cmdlet, as shown here:
Get-MailboxDatabase -Identity DB1 -Status | fl Name,LastFullBackup
How it works...
When you run the Get-MailboxDatabase cmdlet, you must remember to use the -Status switch parameter or else the LastFullBackup property will be $null. In the previous example, we checked the last full backup for the DB1 database and piped the output to the Format-List (using the fl alias) cmdlet. When viewing the LastFullBackup for each database, you might find it helpful to pipe the output to the Select...
