{"id":889,"date":"2018-03-12T21:46:13","date_gmt":"2018-03-12T21:46:13","guid":{"rendered":"http:\/\/ihni.uk\/?p=889"},"modified":"2018-03-12T21:46:13","modified_gmt":"2018-03-12T21:46:13","slug":"empty-redistribute-oversubscribed-exchange-2016-mailboxdb","status":"publish","type":"post","link":"https:\/\/ihni.uk\/?p=889","title":{"rendered":"Empty & Redistribute Oversubscribed Exchange 2016 MailboxDB"},"content":{"rendered":"

In a newly created Exchange 2016 on premise installation I inherited support of, we had 60 MailboxDBs.<\/p>\n

Users were supposed to be provisioned into these evenly from the old environment, but they were lumped into two of the DBs rather than evenly spread…<\/p>\n

So I hacked the following together to empty and move the mail to the other MailboxDBs.<\/p>\n

Once this script has completed, the Mailbox can be deleted and whitespace freed up to release disk space.<\/p>\n

[cc lang=’powershell’]<\/p>\n

######################################################################
\n#
\n# PowerShell Script to Empty an Over utilised Mailbox DB and spread the
\n# load over the remaining Exchange Environment.
\n#
\n# Please be aware that this will totally\u00a0empty the chosen DB.
\n#
\n#######################################################################<\/p>\n

Add-PSSnapin Microsoft.Exchange.Management.Powershell.snapin;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # Load Exchange\/AD Cmndlets<\/p>\n

#$DBs = Get-MailboxDatabase | Select Name | Sort-Object Name
\n$OSMBDB = Read-Host “Please Enter the Oversubscribed MailboxDB name: ” \u00a0# Get OS DB from user
\n$mailboxes = Get-Mailbox -database $OSMBDB | Select name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # Retreive Mailboxes from MailboxDB
\n$mailboxes = $mailboxes.name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # List Mailboxes only by Name
\n$Count = $mailboxes.count\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # Count Mailboxes
\n$ExcludeDB = $OSMBDB -replace ‘[^0-9]’, ”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # Set Over Subscribed DB to be excluded from script
\n$ExcludeDB =[int]$ExcludeDB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # Changes OSDB to an Integer
\n$DBNo = 0;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # Sets Count to zero<\/p>\n

Write-Host “There are $count Mailboxes in $OSMBDB`n”<\/p>\n

ForEach ($mailbox in $mailboxes){
\n$DBno++\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # Incremement Count by 1
\nIf($dbno -eq $ExcludeDB){$dbno++}\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # Skip Excluded DB
\nElseIf ($dbno -gt “59”){$DBNo = 1}\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # Skip DB 60 and Go back to the Start
\n# Prompt for user input to run 10 jobs at a time.This can be changed to be automated, by waiting for all “Get-MoveRequests -Status *Completed*or*Failed*” Can provide Script if needed.
\nElseIf ($dbno -eq “11” -or $dbno -eq “21” -or $dbno -eq “31” -or $dbno -eq “41” -or $dbno -eq “51” -or $dbno -eq “59”){Pause}
\n$dbnoS =$dbno.ToString(“00″)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # Convert Int-String
\nWrite-Verbose ” Preparing to move $mailbox to DB$dbnoS…”\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # Display Prompt, can be output to Log if needed.
\n#New-MoveRequest -Identity $mailbox -TargetDatabase “DB$DBNoS”\u00a0\u00a0\u00a0\u00a0\u00a0 # Command to Move Mailboxes<\/p>\n

}<\/p>\n

[\/cc]<\/p>\n","protected":false},"excerpt":{"rendered":"

In a newly created Exchange 2016 on premise installation I inherited support of, we had…<\/p>\n","protected":false},"author":1,"featured_media":988,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4,19,11],"tags":[32,53],"class_list":["post-889","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-exchange","category-powershell","category-scripts","tag-exchange","tag-mailboxes"],"jetpack_featured_media_url":"https:\/\/ihni.uk\/wp-content\/uploads\/2020\/02\/Powershell.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/posts\/889","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=889"}],"version-history":[{"count":0,"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/posts\/889\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/media\/988"}],"wp:attachment":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=889"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=889"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=889"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}