{"id":1123,"date":"2009-10-26T22:50:34","date_gmt":"2009-10-26T20:50:34","guid":{"rendered":"http:\/\/contoso.se\/blog\/?p=1123"},"modified":"2010-09-01T12:17:54","modified_gmt":"2010-09-01T10:17:54","slug":"check-last-successful-full-backup-of-exchange-2007","status":"publish","type":"post","link":"https:\/\/contoso.se\/blog\/?p=1123","title":{"rendered":"Check last successful full backup of Exchange 2007"},"content":{"rendered":"

I found a nice script from Scott<\/a>\u00c2\u00a0that reports on last successful full backup of Exchange 2007. If you want to do that from Operations Manager 2007 you could modify the power shell script a bit..\u00c2\u00a0The power shell\u00c2\u00a0script below checks when last full backup was made,\u00c2\u00a0it checks for the presence of storage groups and databases within them. You could store the script at your Exchange mailbox servers, in for example C:\\temp\\LastBackupReport.ps1, and then call it from a monitor with a vbscript.<\/p>\n

$iNomHours = “1” #Enter number of hours since last backup that requires attention<\/p>\n

if (-not (Get-PSSnapin Microsoft.Exchange.Management.PowerShell.Admin -ErrorAction SilentlyContinue))
\n\u00c2\u00a0{Add-PSSnapin Microsoft.Exchange.Management.PowerShell.Admin}<\/p>\n

function BackupStatus
\n\u00c2\u00a0{
\n\u00c2\u00a0param($db)
\n\u00c2\u00a0$sBackupRunning = “”
\n\u00c2\u00a0$sCMStatus = $sCheckMark
\n\u00c2\u00a0#Note if backup is currently running
\n\u00c2\u00a0If ($db.BackupInProgress -eq $true)
\n\u00c2\u00a0\u00c2\u00a0{$sBackupRunning = “(Backup In Progress)”}
\n\u00c2\u00a0#Determine if backup has ever completed
\n\u00c2\u00a0If ($db.LastFullBackup -ne $null)
\n\u00c2\u00a0\u00c2\u00a0{
\n\u00c2\u00a0\u00c2\u00a0$sBackupDay = $db.LastFullBackup.get_DayofWeek()
\n\u00c2\u00a0\u00c2\u00a0$sBackupDateTime = $db.LastFullBackup.ToString(“g”)
\n\u00c2\u00a0\u00c2\u00a0#Flag if last completed backup started over 1 hours ago
\n\u00c2\u00a0\u00c2\u00a0If (($date – $db.LastFullBackup).TotalHours -gt $iNomHours)
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0{
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0$sLastBackup = “Last Backup Started: ” + $sBackupDay + “, ” + $sBackupDateTime
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0$sCMStatus = “”
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0$script:bAlert = $true
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0}
\n\u00c2\u00a0\u00c2\u00a0Else
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0{
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0$sLastBackup = “Last Backup Started: ” + $sBackupDay + “, ” + $sBackupDateTime
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0}
\n\u00c2\u00a0\u00c2\u00a0}
\n\u00c2\u00a0Else
\n\u00c2\u00a0\u00c2\u00a0{
\n\u00c2\u00a0\u00c2\u00a0$sLastBackup = “No full backup has completed yet”
\n\u00c2\u00a0\u00c2\u00a0$sCMStatus = “”
\n\u00c2\u00a0\u00c2\u00a0$script:bAlert = $true
\n\u00c2\u00a0\u00c2\u00a0}
\n\u00c2\u00a0$script:sOutput += “” + $sSpace + $sSpace + $db.Name + ” ” + `
\n\u00c2\u00a0\u00c2\u00a0$sLastBackup + “” + $sCMStatus + ” ” + $sBackupRunning + “”
\n\u00c2\u00a0}<\/p>\n

$date = Get-Date
\n$sSpace = ” ”
\n$sOutput = “indicates that no backup started within the configured timeframe, which is ” + $iNomHours + ” hours.”<\/p>\n

#Retrieve Exchange servers with mailbox role
\n$ExServer = Get-ExchangeServer | where {$_.IsMailboxServer -eq $True} | Sort-Object Name
\nForeach ($server in $ExServer)
\n\u00c2\u00a0{
\n\u00c2\u00a0$sOutput += $server
\n\u00c2\u00a0#Retrieve storage groups for a given server
\n\u00c2\u00a0$StorageGroup = $server | Get-StorageGroup | Sort-Object Name
\n\u00c2\u00a0#Check for absence of any storage groups
\n\u00c2\u00a0If (($StorageGroup | Measure-Object Name).Count -eq $null)
\n\u00c2\u00a0\u00c2\u00a0{
\n\u00c2\u00a0\u00c2\u00a0$sOutput += $sSpace + “No storage groups present.”
\n\u00c2\u00a0\u00c2\u00a0}
\n\u00c2\u00a0Else
\n\u00c2\u00a0\u00c2\u00a0{
\n\u00c2\u00a0\u00c2\u00a0Foreach ($sg in $StorageGroup)
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0{
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0$sOutput += $sSpace + $sg.Name
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0#Retrieve mailbox databases for a given storage group
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0$MailboxDatabase = $sg | Get-MailboxDatabase -Status | Sort-Object Name
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0$PFDatabase = $sg | Get-PublicFolderDatabase -Status
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0#Check for absence of any databases in storage group
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0$bMdbExist = ($MailboxDatabase | Measure-Object Name).Count -ne $null
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0$bPFExist = ($PFDatabase | Measure-Object Name).Count -ne $null
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0If ((!$bMdbExist) -and (!$bPFExist))
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0{
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0$sOutput += $sSpace + $sSpace + “No databases in storage group.”
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0}
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0Else
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0{
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0if ($bMdbExist)
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0{
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0Foreach ($mdb in $MailboxDatabase)
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0{
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0BackupStatus $mdb
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0}
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0}
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0if ($bPFExist)
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0{
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0BackupStatus $PFDatabase
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0}
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0}
\n\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0}
\n\u00c2\u00a0\u00c2\u00a0}
\n\u00c2\u00a0}
\n$sOutput += “”
\nIf ($bAlert -eq $true)
\n\u00c2\u00a0{
\n\u00c2\u00a0Write-host “Attention Required”
\n\u00c2\u00a0Write-Host $bAlert
\n\u00c2\u00a0Write-host $sOutput
\n\u00c2\u00a0}
\nElse
\n\u00c2\u00a0{
\n\u00c2\u00a0Write-host “All ok”
\n\u00c2\u00a0}
\n\u00c2\u00a0
\n\u00c2\u00a0<\/p><\/blockquote>\n

The VB script below is used in a timed script two state monitor<\/p>\n

pscommand = “C:\\temp\\LastBackupReport.ps1”
\ncmd = “powershell.exe ” & pscommand
\nSet shell = createObject(“Wscript.Shell”)
\nSet executor = shell.exec(cmd)
\nexecutor.StdIn.Close
\nvarPSResult = executor.StdOut.ReadAll
\nvarString = InStr(varPSResult, “True”)
\nDim oAPI, oBag
\nSet oAPI = CreateObject(“MOM.ScriptAPI”)
\nSet oBag = oAPI.CreatePropertyBag()
\nCall oBag.AddValue(“varPSResult”,varPSResult)
\nIf varString > 1 Then
\nCall oBag.AddValue(“Backup”,”Error”)
\nCall oAPI.Return(oBag)
\nElse
\nCall oBag.AddValue(“Backup”,”Ok”)
\nCall oAPI.Return(oBag)
\nEnd If<\/p><\/blockquote>\n

Settings for the monitor (Timed Script Two State Monitor)<\/p>\n