Exchangemaster GmbH company logo

Exchangemaster GmbH - A Swiss IT Consultancy
Services
References
Partners
Contact
Getting Started
FAQs
Presentations
Articles
Community
Search
Popular
Tell-a-Friend
Follow Me

Follow exchangemaster on Twitter

Who's Online
We have 70 guests online
Syndicate
FAQ 000119 - Exchange Backup Report Script v2.0 PDF Print E-mail
User Rating: / 25
PoorBest 
Written by Dejan Foro   
Sep 23, 2013 at 06:49 PM

This article applies to:

Exchange 2010 SP3

 

The following PowerShell script generates a report on the backup status of all databases in your Exchange 2010 organization.

 

For Exchange 2007 you can use an older version of this script.


<#
.NAME
    ExchangeBackupReport v2.0
.VERSION
    2.0
.AUTHOR
    Dejan Foro,
    Exchangemaster GmbH, www.exchangemaster.net
.DATE
    23rd September 2013
.DESCRIPTION
    The script checks the backup status of all databaseses in your Exchange 2010 organization
#>

cls
Write-Host
Write-Host "Script Name: ExchangeBackupReport v2.0"
Write-Host "Author: Dejan Foro, Exchangemaster GmbH, www.exchangemaster.net"
$OrganizationName = Get-OrganizationConfig | Select-Object -Property Name 
$Date = Get-Date -DisplayHint DateTime
Write-Host
Write-Host "Backup Status Report for All Databases in Exchange Organization" $OrganizationName.Name
Write-Host
Write-Host "Created on" $Date
Write-Host
Write-Host
Write-Host "Backup Status of Mailbox Databases"
Get-MailboxDatabase -Status `
 | where {$_.Recovery -eq $False } `
 | Select-Object -Property Server, Name ,BackupInProgress, LastFullBackup, LastIncrementalBackup, LastDifferentialBAckup, LastCopyBackup, RetainDeletedItemsUntilBackup `
 | Sort-Object -Property Server, Name `
 | Format-Table -AutoSize
Write-Host
Write-Host "Backup Status of Public Folder Databases"
Get-PublicFolderDatabase -Status `
 | Select-Object -Property Server, Name , BackupInProgess, LastFullBackup, LastIncrementalBackup, LastDifferentialBackup, LastCopyBackup, RetainDeletedItemsUntilBackup `
 | Sort-Object -Property Server, Name `
 | Format-Table -AutoSize

 

The script generates an output similar to this one 

 

Script Name: ExchangeBackupReport v2.0
Author: Dejan Foro, Exchangemaster GmbH, www.exchangemaster.net

Backup Status Report for All Databases in Exchange Organization MAIL
Created on 23.09.2013 15:40:57

Backup Status of Mailbox Databases

Server   Name BackupInProgress LastFullBackup      LastIncrementalBackup LastDifferentialBackup LastCopyBackup      RetainDeletedItemsUntilBackup
-------- ---- ---------------- --------------      --------------------- ---------------------- --------------      -----------------------------
SERVER01 DB01            False 20.09.2013 17:01:35                                                                                          False
SERVER01 DB02            False 20.09.2013 17:01:35                                              23.07.2013 18:37:31                         False
SERVER02 DB03            False 20.09.2013 17:01:35                                              23.07.2013 20:19:37                         False
SERVER02 DB04            False 20.09.2013 17:01:35                                              23.07.2013 21:49:31                         False
SERVER03 DB05            False 22.09.2013 17:20:02 23.09.2013 12:05:12                                                                      False
SERVER03 DB06            False 22.09.2013 17:20:03 23.09.2013 12:05:12                                                                      False
SERVER03 DB09            False 22.09.2013 17:20:02 23.09.2013 12:05:12                                                                      False
SERVER04 DB07            False 22.09.2013 17:20:03 23.09.2013 12:05:12                                                                      False
SERVER04 DB08            False 22.09.2013 17:20:02 23.09.2013 12:05:12                                                                      False

Backup Status of Public Folder Databases

Server   Name               BackupInProgess LastFullBackup      LastIncrementalBackup LastDifferentialBackup LastCopyBackup RetainDeletedItemsUntilBackup
-------- ----               --------------- --------------      --------------------- ---------------------- -------------- -----------------------------
SERVER01 Public Folder DB06                 22.09.2013 17:20:03                                                                                     False
SERVER03 Public Folder DB08                 20.09.2013 17:01:35                                                                                     False


Last Updated ( Sep 23, 2013 at 03:03 PM )
<Previous   Next>