I recommend you look at this script instead:
https://www.practical365.com/set-automated-exchange-2010-database-backup-alert-email/

If it doesn’t do exactly what you need then it is quite simple to modify it.

This is Abhishek from New Delhi/ India. Your Script works great in our envt. Thanks for this wonderful script

I am newbie to Powershell, so don’t know much about it, In the Database Backup Alert Email, can you also advise me where to add the field of Last Incremental Backup, Size of databases, space remaining on the drives and threshold of 1 week alert .

Thanks

Thanks

Mailboxes are hosted in databases. Databases are backed up. This script reports on the backup times for databases.

If you want to know which database a mailbox is located in you can run Get-Mailbox to see that information.

Hi Paul,

I mean how to see the last backup per user mailbox with use this script. it is posibble ?

Thank You

I don’t know what you mean by that. A database is a database.

What do “user mailbox” and “database mailbox” mean to you?

How to check last backup per user mailbox not database mailbox ? could this script can do that ?

Thank you

Robert, log on to http://www.microsoftvirtualacademy.com/ and enrol/watch the course ‘Getting Started with PowerShell 3.0 Jump Start’. In that you will learn why double-clicking on a .PS1 file won’t work (and why this is actually a GOOD thing!)

You’ll probably have a bit of a laugh here and there too.

PS – It’s free!

Open notepad, paste the code below in…
Save as something nifty like: “Check Exchange Last Backup.PS1”
——————————————————————————————-

add-pssnapin Microsoft.Exchange.Management.PowerShell.SnapIn
$server = $env:computername

$now = [DateTime]::Now

“Server: ” + $server
“Current time: ” + $now

$db = get-MailboxDatabase -server $server -status
foreach ($objItem in $db)
{
$lastfull = $objItem.lastfullbackup
if (!$lastfull)
{
$fullago = “n/a”
}
else
{
$fullago = $now – $lastfull
$fullago = $fullago.TotalHours
$fullago = “{0:N0}” -f $fullago
}

$lastinc = $objItem.lastincrementalbackup
if (!$lastinc)
{
$incago = “n/a”
}
else
{
$incago = $now – $lastinc
$incago = $incago.TotalHours
$incago = “{0:N0}” -f $incago
}

$returnedObj = new-object PSObject
$returnedObj | add-member NoteProperty -name “Database” -value $objItem.Name
$returnedObj | add-member NoteProperty -name “Last Full (hrs ago)” -value $fullago
$returnedObj | Add-Member NoteProperty -name “Last Inc (hrs ago)” -value $incago
$returnedObj
}

Write-Host “Press any key to continue …”

$x = $host.UI.RawUI.ReadKey(“NoEcho,IncludeKeyDown”)

Thanks Paul

very funky 🙂