How to Export Mailbox Data: Exchange 2007 Help

How to Export Mailbox Data: Exchang...

Collapse All

How to Export Mailbox Data

Applies to: Exchange Server 2007 SP3, Exchange Server 2007 SP2, Exchange Server 2007 SP1, Exchange Server 2007

Topic Last Modified: 2009-08-28

This topic explains how to use the the Export-Mailbox cmdlet in the Exchange Management Shell to export mailbox data from one mailbox to a folder in another mailbox. New functionality is added to the Export-Mailbox cmdlet in Exchange Server Service Pack 1 (SP1).

Note:
You cannot use the Exchange Management Console to export mailbox data.

What Data Is Exported

By default, the Export-Mailbox cmdlet exports all empty folders, special folders, and subfolders to the target location. To specify which folders to include in the export, use the IncludeFolders parameter. To specify which folders to exclude from the export, use the ExcludeFolders parameter.

By default, the following special folders are exported when you use the Export-Mailbox cmdlet:

Inbox
Deleted Items
Drafts
Junk E-Mail
Outbox
Sent Items
Journal
Calendar
Contacts
Notes
Tasks

The Export-Mailbox cmdlet exports all message types, including messages, calendar items, contacts, distribution lists, journal entries, tasks, notes, and documents. However, the Export-Mailbox cmdlet does not export rules.

The Export-Mailbox cmdlet also exports messages from the dumpster. Messages from the dumpster are converted to regular items in the folder or .pst file to which you export data.

Note:
If you use any keyword parameters, the Export-Mailbox cmdlet will first export all of the messages, including messages in the dumpster, and then search the target mailbox for messages that meet the keyword criteria. Messages that were in the dumpster on the source mailbox are converted to regular messages in the Deleted Items folder on the target mailbox and will also be searched for keywords. The Export-Mailbox cmdlet then deletes messages on the target mailbox that do not match the keyword criteria. If you also use the DeleteContent parameter, Export-Mailbox will then delete the messages that match the keyword criteria from the source mailbox.

Note:

If you use any keyword parameters, the Export-Mailbox cmdlet will first export all of the messages, including messages in the dumpster, and then search the target mailbox for messages that meet the keyword criteria. Messages that were in the dumpster on the source mailbox are converted to regular messages in the Deleted Items folder on the target mailbox and will also be searched for keywords. The Export-Mailbox cmdlet then deletes messages on the target mailbox that do not match the keyword criteria. If you also use the DeleteContent parameter, Export-Mailbox will then delete the messages that match the keyword criteria from the source mailbox.

For more information about messages in the transport dumpster, see How to Recover a Deleted Item.

Where Data Is Exported

Data is exported to a subfolder in a destination mailbox and folder that you specify. To specify the destination mailbox, use the TargetMailbox parameter. To specify the folder on the destination mailbox, use the TargetFolder parameter. The TargetFolder parameter specifies the top-level mailbox folder that is created on the destination mailbox. This folder contains a subfolder named Recovered Data - <Source_Mailbox_Alias> - <Date_Time_Stamp>. The subfolder contains the exported folders and messages.

If the target folder that you specify already exists on the target mailbox, the exported data is added to the existing folder. If the target folder does not exist, it is created.

New in Exchange 2007 Service Pack 1 (SP1)

Exchange 2007 Service Pack 1 (SP1) introduces the following functionality for exporting mailbox data:

You can export mailbox data from a mailbox to a .pst file. To export to a .pst file, use the PSTFolderPath parameter to specify the path to the .pst file to which data will be exported. You cannot export data to a .pst file from a mailbox that is in a recovery storage group (RSG).
You can merge the data that you export into an existing target folder by using the AllowMerge parameter. In Exchange 2007 SP1, if you specify the AllowMerge parameter, the name of the subfolder will not include a date-time stamp. In Exchange 2007 SP1, you can specify a path to a .pst file to which data will be exported instead of specifying a target mailbox and target folder.
You can use the DeleteAssociatedMessages parameter to delete associated messages in the export process. Or, use the IncludeAssociatedMessages parameter to include associated messages in the export process. Associated messages contain hidden data with information about rules, views, and forms.
If you use the DeleteContent parameter and do not specify the TargetMailbox parameter, you can delete content from the source mailbox without exporting it to another mailbox.
You can filter the messages that are exported based on recipients and senders. To filter on recipients, use the RecipientKeywords parameter. To filter on the sender, use the SenderKeywords parameter.

For more information about the new functionality that is introduced by Exchange 2007 SP1, see the Export-Mailbox topic.

For more information about the functionality prior to Exchange 2007 SP1, see the Export-Mailbox (RTM) topic.

Before You Begin

To perform this procedure, the account you use must be delegated the following:

Exchange Server Administrators role and local Administrators group for the source server and the target server
Full access to the source and target mailboxes

For more information about permissions, delegating roles, and the rights that are required to administer Exchange 2007, see Permission Considerations.

Also, before you perform this procedure, be aware of the following:

To use the Export-Mailbox cmdlet, the source mailbox and target mailbox must be in the same forest. You cannot export data from a mailbox in one forest to a mailbox in a different forest.
You cannot export data from a public folder database.
To grant full access to a mailbox, use the Add-MailboxPermission cmdlet and specify FullAccess for the AccessRights parameter. For example, if Admin01 needs to export data from John's mailbox to a mailbox called Export, you must first run the following commands:
```
Add-MailboxPermission -Identity john -User Admin01 -AccessRights FullAccess
Add-MailboxPermission -Identity Export -User Admin01 -AccessRights FullAccess
```
To export data from an Exchange 2003 or Exchange 2000 mailbox, the account you use must be delegated the Exchange Administrator role for the administrative group in which the server resides.
To export data from a .pst file, you must run the Export-Mailbox cmdlet from a 32-bit computer that has the following installed:
- The 32-bit version of the Exchange management tools
- Outlook 2003 Service Pack 2 (SP2) or Outlook 2007
For information about Exchange 2007 management tools 32-bit download, see Microsoft Exchange Server 2007 Management Tools (32-Bit).
If you export data to a folder in another mailbox, the target mailbox that you specify must exist before you run the command.

Procedure

Exchange 2007 SP1

To use the Exchange Management Shell to export mailbox data in Exchange 2007 SP1

To export the special folders and empty folders of the mailbox to a folder in the destination mailbox, run the following command:
```
Export-Mailbox -Identity <MailboxIdParameter> -TargetMailbox <MailboxIdParameter> -TargetFolder <Folder_Name>
```

To export data to a .pst file, run the following command:

Export-Mailbox -Identity <MailboxIdParameter> -PSTFolderPath <Path_Of_PST_Folder>\<File_Name>.pst

To export data from a group of mailboxes, such as all mailboxes for which the user title begins with "VP," run the following command:
```
Get-User | where { $_.Title -ilike "VP*" } | Export-Mailbox -TargetFolder <Folder_Name> -TargetMailbox <MailboxIdParameter>
```

To export data that was received between specific dates to a .pst file, run the following command:

Export-Mailbox -Identity <MailboxIdParameter> -StartDate "<Month/Day/Year>" -EndDate "<Month/Day/Year>" -PSTFolderPath <Path_Of_PST_Folder>\<File_Name>.pst

To export only data from the Sent Items folder, run the following command:

Export-Mailbox -Identity <MailboxIdParameter> -IncludeFolders '\Sent Items' -TargetFolder <Target_Folder_Name> -TargetMailbox <MailboxIdParameter>

To exclude folders from the export, such as excluding items in the Junk E-Mail and Contacts folders, run the following command:

Export-Mailbox -TargetMailbox <MailboxIdParameter> -TargetFolder <Target_Folder_Name> -ExcludeFolders "\Junk E-Mail","\Contacts"

To use filters to specify which items in the source mailbox to include in the export, run the following command:

Export-Mailbox -Identity <MailboxIdParameter> -TargetMailbox <MailboxIdParameter> -TargetFolder <Target_Folder_Name> -ContentKeywords "<String[]>" -AttachmentFilenames "<String[]>" -StartDate "<Month/Day/Year> <Time>" -RecipientKeywords <String[]>

To find and delete items from a group of mailboxes, such as all mailboxes on a database, run the following command:
```
Get-Mailbox -Database DB1 | Export-Mailbox -TargetMailbox ExportMailbox -TargetFolder VirusData -SubjectKeywords "Virus message" -DeleteContent
```
This example first gets all the mailboxes on database DB1 and then searches for items that contain the string "Virus message" in the subject line. It will export the items to the mailbox ExportMailbox and will delete those items from the source mailbox.
To find and delete items from a group of mailboxes, such as all mailboxes on a database, without exporting the items to another mailbox, run the following command:
```
Get-Mailbox -Database DB1 | Export-Mailbox -SubjectKeywords "Virus message" -DeleteContent
```
This example first gets all the mailboxes on database DB1, searches for items that contain the string "Virus message" in the subject, and deletes those items.
To export data from all the mailboxes of users in the Marketing organizational unit, run the following command:
```
Get-Mailbox -OrganizationalUnit Marketing | Export-Mailbox -PSTFolderPath C:\PSTFiles
```
This example exports the data from each mailbox to a separate .pst file located at C:\PSTFiles. The name of each .pst file will be <alias>.pst.

For detailed syntax and parameter information, see the Export-Mailbox reference topic.

Exchange 2007 RTM

To use the Exchange Management Shell to export mailbox data in Exchange 2007 RTM

To export the special folders and empty folders of the mailbox to a folder in the destination mailbox, run the following command:
```
Export-Mailbox -Identity <MailboxIdParameter> -TargetMailbox ExportMailbox -TargetFolder <Folder_Name>
```
To export data from a group of mailboxes, such as all mailboxes for which the user title begins with "VP," run the following command:
```
Get-User | where { $_.Title -ilike "VP*" } | Export-Mailbox -TargetFolder <Folder_Name> -TargetMailbox <MailboxIdParameter>
```

To export data received between specific dates, run the following command:

Export-Mailbox -Identity <MailboxIdParameter> -StartDate "<Month/Day/Year>" -EndDate "<Month/Day/Year>" -TargetFolder <Folder_Name> -TargetMailbox <MailboxIdParameter>

To export only data from the Sent Items folder, run the following command:

Export-Mailbox -Identity <MailboxIdParameter> -IncludeFolders '\Sent Items' -TargetFolder <Target_Folder_Name> -TargetMailbox <MailboxIdParameter>

To exclude folders from the export, such as excluding items in the Junk E-Mail and Contacts folders, run the following command:

Export-Mailbox -TargetMailbox <MailboxIdParameter> -TargetFolder <Target_Folder_Name> -ExcludeFolders "\Junk E-Mail","\Contacts"

To use filters to specify which items in the source mailbox to include in the export, run the following command:

Export-Mailbox -Identity <MailboxIdParameter> -TargetMailbox <MailboxIdParameter> -TargetFolder <Target_Folder_Name> -ContentKeywords "<String[]>" -AttachmentFilenames "<String[]>" -StartDate "<Month/Day/Year> <Time>"

To find and delete items from a group of mailboxes, such as all mailboxes on a database, run the following command:
```
Get-Mailbox -Database DB1 | Export-Mailbox -TargetMailbox ExportMailbox -TargetFolder VirusData -SubjectKeywords "Virus message" -DeleteContent
```
This example first gets all the mailboxes on database DB1 and then searches for items that contain the string "Virus message" in the subject. It will export the items to the mailbox ExportMailbox and will delete those items from the source mailbox.

For detailed syntax and parameter information, see the Export-Mailbox (RTM) reference topic.

Replacing ExMerge.exe

In Exchange 2003 or Exchange 2000, you can use the Microsoft Exchange Server Mailbox Merge wizard (ExMerge.exe) to export mailbox data. The following table lists scenarios for using ExMerge.exe in Exchange 2003 or Exchange 2000, and the solution for performing this task in Exchange 2007.

Scenario in Exchange 2003 and Exchange 2000	Exchange 2003 and Exchange 2000 resources	Exchange 2007 solution
Use ExMerge.exe in Exchange 2003 or Exchange 2000 in recovery scenarios to move the recovered data from the recovery storage group to another database.	For information about the Exchange 2003 scenario, see Microsoft Knowledge Base article 823176, How to recover or to restore a single mailbox in Exchange Server 2003. For information about the Exchange 2000 scenario, see Microsoft Knowledge Base article 813337, How to recover or restore a single mailbox in Exchange 2000 Server.	To perform this task in Exchange 2007, use the Restore-Mailbox cmdlet. For more information, see How to Recover a Mailbox by Using a Recovery Storage Group.
Use ExMerge.exe in Exchange 2003 or Exchange 2000 to export user data from a corrupted database to a .pst file, and then from the .pst file to a new database.	For information about the Exchange 2003 or Exchange 2000 scenario, see Microsoft Knowledge Base article 313184, How to recover the information store on Exchange 2000 Server or Exchange Server 2003 in a single site.	To perform this task in Exchange 2007, use the Restore-Mailbox cmdlet to restore the data from backup, and then use the Move-Mailbox cmdlet. For more information, see Restore-Mailbox and Move-Mailbox.
Use ExMerge.exe in Exchange 2003 or Exchange 2000 to move mailboxes to a different server.	For information about the Exchange 2003 or Exchange 2000 scenario, see Microsoft Knowledge Base article 328810, Moving mailboxes between servers.	To perform this task in Exchange 2007, use either the Move Mailbox wizard or the Move-Mailbox cmdlet. For more information, see How to Move a Mailbox Within a Single Forest or How to Move a Mailbox Across Forests.
Use ExMerge.exe in Exchange 2003 or Exchange 2000 to remove a specific message that was sent to users in your Exchange organization. For example, you may want to delete a virus message or a confidential message that was sent inadvertently.	For more information about the Exchange 2003 or Exchange 2000 scenario, see Microsoft Knowledge Base article 328202, HOW TO: Remove a Virus-Infected Message from Mailboxes by Using the ExMerge.exe Tool.	To perform this task in Exchange 2007, use the Export-Mailbox cmdlet with the DeleteContent parameter and any of the content filtering parameters, such as AllContentKeywords, AttachmentFilenames, ContentKeywords, SubjectKeywords, StartDate, or EndDate. For more information, see Export-Mailbox.
Use ExMerge.exe in Exchange 2003 or Exchange 2000 to find a specific message that was sent to users in your Exchange organization, or to find all messages with specific words in the subject, message body, or attachments.	For more information about the Exchange 2003 or Exchange 2000 scenario, see Microsoft Knowledge Base article 246916, XADM: How to Find Mailboxes That Contain a Specific Message.	To perform this task in Exchange 2007, use the Export-Mailbox cmdlet with any of the content filtering parameters, such as AllContentKeywords, AttachmentFilenames, ContentKeywords, SubjectKeywords, StartDate, or EndDate, but without the DeleteContent parameter. For more information, see Export-Mailbox.
Use ExMerge.exe in Exchange 2003 or Exchange 2000 as an alternative way to restore mailbox data if you have problems during a mailbox move.	None	To perform this task in Exchange 2007, use the Restore-Mailbox cmdlet to restore mailbox data, and use the Move-Mailbox cmdlet to move mailboxes. For more information, see Restore-Mailbox and Move-Mailbox.
Use ExMerge.exe in Exchange 2003 or Exchange 2000 to export data to a .pst file. For example, if you are in a hosting scenario, you may want to send mailbox content to a former user in the organization.	None	To perform this task in Exchange 2007 SP1, use the PSTFolderPath parameter. To perform this task in Exchange 2007 RTM, you have two options: Log on to the mailbox that is running Microsoft Outlook, and then use Outlook to export the data to a .pst file. Use the Export-Mailbox cmdlet to export the data from several mailboxes to a single, separate mailbox, and then log on to that mailbox and use Outlook to export the data to a .pst file. For more information about this scenario, see the Exchange Server Team Blog article Exchange Server 2007 Export Mailbox task. Note: The content of each blog and its URL are subject to change without notice. The content within each blog is provided "AS IS" with no warranties, and confers no rights. Use of included script samples or code is subject to the terms specified in the Microsoft Terms of Use.

For More Information

For more information about importing mailbox data from a .pst file, see How to Import Mailbox Data.

Tags

: Add a tag

Community Content

Add new content

Annotations

Having a problem Deleting Messages

bwgreen9 | Edit | Show History

I am trying to use Export-Mailbox to delete messages from the server. I have a list of user mailboxes to search and delete from, and I use the command

get-mailbox -Identity "UserName" | Export-Mailbox -ContentKeywords "What I am Searching For" - TargetMailbox me@me -TargetFolder Errors -DeleteContent

This creates folders in my mailbox showing the messages that match what I am looking for, but if I keep running this it keeps fidning matches, instead of coming up empty because the messages are gone. Or are they only MARKED for deletion - and is there a way to get rid of them?

Thanks,

Brian

Tags

: Add a tag

Flag as ContentBug

empty?!

brian7 | Edit | Show History

OK.. i have tried many different variations of powershell commands:
Import-Csv “C:\Users.CSV” | ForEach-Object {Export-Mailbox -Identity $_.Alias -ContentKeywords <your text> -StartDate "MM/DD/YYYY" -EndDate "MM/DD/YYYY" -DeleteContent -PSTFolderPath C:\PSTFiles -Confirm:$False}

I get no errors and all it does is build an empty folder structure in the pst. What am i missing!?

Tags

: Add a tag

Flag as ContentBug

Why can't you export from the 64-bit server?

njleach | Edit | Show History

It is just ludicrous that you have to install the 32-bit exchange server management tools (an 800MB download) in order to be able to export a mailbox on a 64-bit server environment to PST and are unable to do it directly from the server.

Tags

: Add a tag

Flag as ContentBug

How to overcome Export-Mailbox errors and frustrations

theycallmePete | Edit | Show History

I have had mixed success with the Export-Mailbox command in the past. In one case, I absolutely needed to perform an Export of a Mailbox and given the numerous errors and failures ended opening up a ticket with Microsoft. Their response was that the mailbox was "corrupt" and the only way to overcome this "corruption" was to move the mailbox to another store or run ESEUTIL and fix any logical corruption(not going to happen in production system).

Anyhow, I moved the mailbox and it did the trick, however, I did a bit of Investigation and Experimentation and found that in the vast majority of the cases the items in the Dumpsters were the culprit. When I run into Export-Mailbox issues, I cleanup or restore any items in the users mailbox dumpster(s) (since they are going to be restored anyways when you export) rerun the cmdlet, and in over 95% of the cases it succeeds.

Just my 2 cents on the subject and MS, pleeeeease bring Ex-Merge back!

Tags

: Add a tag

Flag as ContentBug

command does not work??? Any suggestions?

Balpher | Edit | Show History

[PS] C:\Windows\system32>Export-Mailbox -Identity nng -StartDate "5/29/2009" -En
dDate "1/7/2011" -PSTFolderPath c:\archive\nng.pst
Export-Mailbox : The specified mailbox database "CRANK\Second Storage Group\Sal
es and Assignment Desk2" does not exist.
At line:1 char:15
+ Export-Mailbox <<<< -Identity nng -StartDate "5/29/2009" -EndDate "1/7/2011"
-PSTFolderPath c:\archive\nng.pst
+ CategoryInfo : InvalidData: (0:Int32) [Export-Mailbox], Managem
entObjectNotFoundException
+ FullyQualifiedErrorId : 816C210B,Microsoft.Exchange.Management.Recipient
Tasks.ExportMailbox

Tags

: Add a tag

Flag as ContentBug

32bit exchange 2k7??!!

rkismet | Edit | Show History

Anyone else find it kinda retarded that one has to use a 32bit machine to run these commands? besides the 64bit push on the client side, one of the requirements to install exchange 2k7 is that its a 64bit box!!?! WTF is that? ***, why isnt this stuff in the gui console? its great that we can script this stuff out if we want now (most of it being a PITA) but nothing beats a right click > "chose option" for the one off stuff...this is getting very over complacated for no reason...

Tags

: Add a tag

Flag as ContentBug

Export to PST not working on SP2

digitalson | Edit | Show History

I get errors exporting from Powershell to PST file on an 2007 SP2 Exchange Server regarding the 64-bit compatibility. IS there any special updates that need to be done to update the export-mailbox script? This functionality appears to be broken..

Tags

: Add a tag

Flag as ContentBug

Permissions

Andres P | Edit | Show History

If You get "Failed to copy messages to the destination mailbox store with error: An unknown error has occurred., error code: -1056749164"
check source mailbox permissions. Even if user (under which contect export is running) is Exch full admin, grant him full access to this mailbox.

Tags

: Add a tag

Flag as ContentBug

Does not work export to pst

ZRoman | Edit | Show History

Dont forget to turn off Outlook while exporting.

Tags

: export-mailbox (x) Add a tag

Flag as ContentBug

It does not work ...

Commodore128 | Edit | Show History

The cmdlet generates error, help!

get-mailbox -Identity c8042403 | Export-Mailbox -SubjectKeywords "JMGC 80424034" -TargetMailbox zalertas -TargetFolder Prueba

Error generated:

Error occurred in the step: Creating target folder in the target mailbox. An unknown error has occurred., error code: -2147221233

Tags

: Add a tag

Flag as ContentBug

Minor error

Jetze Mellema | Edit | Show History

"To export data from a .pst file, you must run the Export-Mailbox cmdlet from a 32-bit computer that has the following installed:"

I think this should be:
"To export data to a .pst file, you must run the Export-Mailbox cmdlet from a 32-bit computer that has the following installed:"

Tags

: contentbug (x) Add a tag

Remark regarding export to PST

dsidler | Edit | Show History

One thing I found highly irritating while exporting a mailbox to .pst was that the status bar said "moving messages ...", while I only wanted to COPY messages to the target file. Made my blood freeze for a second. Maybe you can clarify in the documentation of the command that only with the -DeleteContent switch, items will be removed from the source folders.

Tags

: Add a tag

Flag as ContentBug

Vanishing Emails

HybridMoments82 | Edit | Show History

I successfully run the following:

get-mailbox -Database "Mailbox Database" | Export-Mailbox -SubjectKeywords "Keywords" -TargetMailbox Administrator -TargetFolder Data

While the command is running, I open Administrator in an Outlook client and notice that the emails that meet the criteria are dumped into their respective folders and then, almost instantly, vanish. At the end of the query, I'm left with just a ton of empty directories.

Any suggestions?

Tags

: Add a tag

Flag as ContentBug

@nironixon - Deleting emails

WileyIain | Edit | Show History

Hi, you don't seem to have specified a location for the exported mails to go to. You need to put in either a -TargetMailbox or a -PSTFolderPath parameter. I don't think the command will work at all if you don't give it a location to send the files to as it's an export command, not a delete command.

I guess that as you no longer need these messages, you should do something like this:

Export-Mailbox -Identity "support" -PSTFolderPath c:\deletedmail.pst -DeleteContent -StartDate "01/12/2008" -EndDate "01/01/2009"

Once this has run then you can delete the PST and the mails will be gone.

Tags

: Add a tag

Flag as ContentBug

Delete Folders after export ?

TheOtherDude | Edit | Show History

Hi, I successfully run

export-mailbox -id INVUSERID -PSTFolderPath E:\TEMP\USERID.pst -DeleteContent -confirm:$false

and the items as messages, tasks, calendar entries all get's deleted after export. However, the folder structure stays in there and hence recover from deleted items is still possible. How can I delete the folder "Recovered Data - USER ID - DATE" from the INVUSERID inbox after export or with an additional cmdlet ???

Tags

: Add a tag

Flag as ContentBug

Deleteing emails???

nironixon | Edit | Show History

Hi there, i have now for hours trying to delete emails from an inbox:

[PS] U:\>Add-MailboxPermission -Identity support -User myAccount -AccessRights FullAccess

Where "myAccount" is my current domain login / mail account.[PS] U:\>Export-Mailbox -Identity "support" -DeleteContent -StartDate "01/12/2008" -EndDate "01/01/2009"

However, i keep getting the same error message:

Export-Mailbox : Error was found for Support (xxxx) because: Err
or occurred in the step: Moving messages. Failed to copy messages to the destin
ation mailbox store with error: An unknown error has occurred., error code: -10
56749164
At line:1 char:15
+ Export-Mailbox <<<< -Identity "support" -DeleteContent -StartDate "01/12/200
8" -EndDate "01/01/2009"

I have service pack 1 and Rollup 5 installed.

Anyone have been more successfull than me?

Tags

: Add a tag

Flag as ContentBug