Book Image

Microsoft Exchange Server PowerShell Cookbook

Book Image

Microsoft Exchange Server PowerShell Cookbook

Overview of this book

Table of Contents (21 chapters)
Microsoft Exchange Server PowerShell Cookbook Third Edition
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

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 time for the DB1 database and piped the output to the Format-List (using the fl alias) cmdlet. When viewing the LastFullBackup property for each database, you might find it helpful to pipe the output...