For a global customer with terrabytes of Exchange 2013 data, I recently wrote a multi-threading powershell script I’d like to share with everyone.<\/p>\n
The use case was an integrity check of the database backups prior to Exchange maintenance. First we have to commit all log files to a large number of databases, then run a\u00a0surface or deep\u00a0check on these databases before\u00a0we can be relatively sure a restore won’t fail.<\/p>\n
All database backups were mounted to mountpoints in a root folder on a windows server. Each database had it’s own subfolder in the root folder, the logfiles were in the same folder as the .edb file.<\/p>\n
ESEUtil<\/a>\u00a0is our tool of choice when running integrity checks on Exchange databases. The tool has to be installed on the same server, the executable path is then referenced in the script.<\/p>\n Summarization<\/strong><\/p>\n Once completed, we’re ready to configure\u00a0the script. The script is multi-threading, which means it can check several databases at once. \u00a0I recommend using CPU’s-1 threads. Note that ESEUtil can use up a LOT of memory.<\/p>\n Script configuration<\/strong><\/p>\n $DBPath \u00a0 \u00a0 \u00a0= “D:\\DATABASES” \u00a0#This is the path to the folder on your machine where you mounted each database to subfolder (example: D:\\DATASES\\DB01)<\/p>\n $LogFile \u00a0 \u00a0 = “D:\\DATABASES\\Log.txt” #Results will be written here, including errors ESEUtil spills out<\/p>\n $ESEUtil \u00a0 \u00a0 = ‘D:\\ESEutil\\eseutil.exe’ #Path to ESEUtil.exe<\/p>\n $maxThreads \u00a0= 4 #Number of concurrent checks to run<\/p>\n $deepscan = $true #Set to $False if you only want to run a \/mh instead of \/g after commit<\/p>\n Running the script<\/strong><\/p>\n The script is now ready to run, right click EDBChecker_V0.3.ps1 and choose Run with Powershell. You’ll see a window, it’ll take some time to load and you’ll see a progress bar come up. Checking databases with \/g can take a very long time (hours) per database, you can monitor eseutil with your task manager. Once databases have been checked, a line will be written to the log file. \u00a0Once repaired, another line will be written and the job engine will move on to the next database.<\/p>\n The script<\/b><\/p>\n EdbChecker_V0.3<\/a><\/p>\n Note: EdbChecker_V0.3Thread.ps1 is a required file and should be in the same folder as EdbChecker_V0.3.ps1, but should not be run.<\/p>\n Edit<\/strong><\/p>\n And for advanced users, if you want to be really cool and let your Offline drives in drive manager automatically get mapped to a mountpoint, so you don’t have to manually assign a mountpoint to each disk, you may modify this snippet:<\/p>\n foreach($disk in Get-Disk | where-object {$_.AllocatedSize \/1GB -gt 2450}){ if($disk.IsReadOnly){ Get-Partition -DiskNumber $disk.Number | where-object {$_.DriveLetter} | % { Get-Partition -DiskNumber $disk.Number | where-object {$_.Size \/1GB -gt 2450} | % { You’ll have to modify the where-object clauses to select the correct disk\/partition in your situation. In my situation they were over 2450GB in size, and all other disks weren’t.<\/p>\n","protected":false},"excerpt":{"rendered":" For a global customer with terrabytes of Exchange 2013 data, I recently wrote a multi-threading powershell script I’d like to share with everyone. The use case was an integrity check of the database backups prior to Exchange maintenance. First we have to commit all log files to a large number of databases, then run a\u00a0surface … Continue reading Multi-Threading Powershell script to Check and Repair numerous Exchange databases<\/span> \n
$root = \"D:\\mountpoint\\\"<\/code><\/p>\n
\nif($disk.IsOffline){
\nSet-Disk -Number $disk.Number -IsOffline $False
\n}<\/p>\n
\nSet-Disk -Number $disk.Number -IsReadonly $False
\n}<\/p>\n
\n$drive = “$($_.DriveLetter):”
\nremove-partitionaccesspath -disknumber $disk.Number -partitionnumber $_.PartitionNumber -accesspath $drive
\n}<\/p>\n
\n$foldername = “$($disk.Number)$($_.PartitionNumber)”
\n$foldername = “$($root)$($foldername)”
\nNew-Item $foldername -type directory
\nadd-partitionaccesspath -disknumber $disk.Number -partitionnumber $_.PartitionNumber -accesspath $foldername
\n}
\n}<\/p>\n