Any system administrator responsible for a Microsoft Exchange environment will, most likely, at some point need to interact and troubleshoot Exchange Database (EDB) files. Mailbox databases are stored in the EDB file format. Contained within an EDB file are in-process and non-SMTP messages.
Instead of using the Exchange Admin Center to interact with EDB files, you can use PowerShell.
During normal operations, you don't usually need to worry about EDB files. Though they are an integral piece to the functioning of Exchange, day to day operations often don't involve the databases directly. As stated above, there are a number of scenarios that can call for more direct intervention.
Provided by the Exchange Management Tools, a PowerShell module for managing Exchange is available. Most likely these tools would be installed on your Exchange Server as available in the following instructions.
Let's dive into some interesting scenarios you might find yourself in.
Loading Exchange Management PowerShell
Note some of these cmdlets are only available for on-premises Exchange.
The generally recommend approached to using the module is via a PowerShell Remoting session to connect remotely to the Exchange Server and load the Exchange cmdlets as shown below.
PS> Set-ExecutionPolicy RemoteSigned PS> $UserCredential = Get-Credential PS> $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri http://<ServerFQDN>/PowerShell/ -Authentication Kerberos -Credential $UserCredential PS> Import-PSSession $Session -DisableNameChecking
Make sure to remove the connection from your PowerShell session when you are done via the command:
Default Locations of EDB Files
Each version of Exchange puts the EDB files in a slightly different location. You'll see the default locations below. This can come in handy when interacting with these files directly, though with the available PowerShell commands, you may not have to!
- Exchange Server 2010
C:\Program Files\Microsoft\Exchange Server\V14\Mailbox Database\
- Exchange Server 2013
C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database Name\
- Exchange Server 2016 & 2019
C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\
Finding Mailboxes with Get-MailboxDatabase
Often you just need to know where a given mailbox database is located or any of the many properties available. You can use the
Get-MailboxDatabase cmdlet to find a lot of useful information about an Exchange database as seen below.
Though there are many properties returned, we are just interested in the
EdbFilePath, and it's
Mounted status. To retrieve the actual
mounted value, use the
Status parameter, otherwise no value will be output.
Dismounting Exchange Databases with Dismount-Database
Now that you have some information on your mailbox database, you might choose to dismount the database. To do that, use the
The default directory where the EDB files are located isn't ideal. You may have a better performing and more manageable location to move them to. Before you can do that though, you must dismount the database as shown below.
Moving Mailbox Databases with Move-DatabasePath
Since you have dismounted the database, now move the mailbox database to a new location. This is done using the appropriately named,
Wait! What if we had circular logging turned on? According to the best practices for moving database files, this needs to be turned off. To do this, use the
Depending on our environment there may be some extra steps to take before doing that. Notably you may need to remove existing mailbox database copies. Mailbox database copies are copies of a database that are distributed and replicated among your Exchange servers. Don't worry, even though we are removing them here, we are going to add them back!
You should now be able to move the database to the new location. Running
Move-DatabasePath will actually relocate the database files to a new path, provided the database is dismounted.
Success! The databases are moved, now add back the database copies and also turn circular logging back on as shown below.
PS> Add-MailboxDatabaseCopy -Identity MyExchangeDatabase PS> Set-MailboxDatabase -Name MyExchangeDatabase -CircularLoggingEnabled:$True
Fixing Corrupted Mailboxes with New-MailboxRepairRequest
After the database move, perhaps you'd like to ensure there aren't any corrupted mailboxes on the database. Conveniently there is a command for that called
New-MailboxRepairRequest. This command can be run on an individual mailbox or, if run without parameters ,on all mailboxes within a given database as shown below.
Important! After you begin the repair request, you must dismount the database to stop the process. Additionally, only the mailbox being repaired is inaccessible, all others remain accessible during the database repair.
Gluing PowerShell and ESEUTIL Together
One of the powerful capabilities with PowerShell is the ability to glue many different tools together. A go-to utility for many Exchange Administrators is
Perhaps you'd like to defragment an EDB file. Defragmentation can be done via
eseutil. An example of this is the following script that illustrates combining PowerShell with standard shell utilities.
PS> Set-Location -Path (Split-Path (Get-MailboxDatabase -Name MyExchangeDatabase).EdbFilePath) PS> Dismount-Database -Name MyExchangeDatabase PS> eseutil /d MyExchangeDatabase.edb / PS> Mount-Database -Name MyExchangeDatabase
Note that when you start defragmentation on a database, your users cannot access any mailboxes stored in that database. Additionally, you will need about 110 percent the size of the database on disk to perform the defragmentation.
Although you can do many of the operations via the Exchange Admin Center, a best practice to administration is that of automation and repeatability. By leveraging PowerShell, you can limit common admin repetitions through automating many common scenarios, ultimately saving time and preventing headaches!
Subscribe to Adam the Automator
Get the latest posts delivered right to your inbox