after disconnect one of the usermail box, when i would like reconnect back the usemail box under -->recipient configuration--> disconnected mailbox. it will popup an error msg as below Microsoft CorporationMicrosoft Windows Operating System5.2.3790.3959Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.System.Data.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. at System.Data.DataTable.EnableConstraints() at System.Data.DataTable.set_EnforceConstraints(Boolean value) at System.Data.DataTable.EndLoadData() at Microsoft.Exchange.Management.SystemManager.DataTableLoader.MoveRows(DataTable sourceTable, DataTable destinationTable, Boolean forceUseMergeTable) at Microsoft.Exchange.Management.SystemManager.DataTableLoader.OnDoRefreshWork(RefreshRequestEventArgs e) at Microsoft.Exchange.Management.SnapIn.Esm.Recipients.DisconnMailboxesDataSource.OnDoRefreshWork(RefreshRequestEventArgs e) at Microsoft.Exchange.Management.SystemManager.RefreshableComponent.worker_DoWork(Object sender, DoWorkEventArgs e) at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument) mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089Microsoft.ManagementConsole, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35MMCFxCommon, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3aSystem.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3aSystem.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089Microsoft.Exchange.Management.SnapIn.Esm, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Microsoft.Exchange.Management.SystemManager, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Microsoft.Exchange.Data.Directory, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Microsoft.Exchange.Data, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Microsoft.Exchange.Diagnostics, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Microsoft.Exchange.Data.Common, Version=8.0.681.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089Microsoft.Exchange.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Microsoft.Exchange.Management.SystemManager.resources, Version=8.0.0.0, Culture=en, PublicKeyToken=31bf3856ad364e35System.Drawing.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3aMicrosoft.Exchange.Management.SnapIn.Esm.resources, Version=8.0.0.0, Culture=en, PublicKeyToken=31bf3856ad364e35Microsoft.Exchange.Configuration.ObjectModel, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Microsoft.Exchange.Management, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35System.Management.Automation, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35System.DirectoryServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3aSystem.DirectoryServices.Protocols, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3aMicrosoft.Exchange.Rpc, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35msvcm80, Version=8.0.50727.1433, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3aMicrosoft.Exchange.Extensibility.Internal, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Microsoft.Exchange.Configuration.ObjectModel.resources, Version=8.0.0.0, Culture=en, PublicKeyToken=31bf3856ad364e35System.Configuration.Install, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3aMicrosoft.PowerShell.ConsoleHost, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Microsoft.PowerShell.Commands.Management, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35System.ServiceProcess, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3aMicrosoft.PowerShell.Security, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Microsoft.PowerShell.Commands.Utility, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Microsoft.Exchange.PowerShell.Configuration, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Microsoft.Exchange.Transport.Logging.Search, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Microsoft.Exchange.MessagingPolicies.Rules, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Microsoft.Exchange.Net, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Microsoft.Exchange.MessageSecurity, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Microsoft.Exchange.Cluster.Replay, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Microsoft.Exchange.Data.Mapi, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Microsoft.Exchange.UM.Management, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35Microsoft.Exchange.ContentIndexing.Tasks, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35System.Management, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3aAccessibility, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3aSystem.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3aMicrosoft.Exchange.Data.resources, Version=8.0.0.0, Culture=en, PublicKeyToken=31bf3856ad364e35Microsoft.Exchange.Data.Directory.resources, Version=8.0.0.0, Culture=en, PublicKeyToken=31bf3856ad364e35Microsoft.Exchange.StoreProvider, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 does any guy facing this issue before?can share with me how to solve it ? thank you

Hello, Did you try by connecting mailbox with Connect-Mailbox command? Reference: How to Connect a Mailbox Try to clear the views in your profile: To clear the views, start-> run MMC, in the console window, click file->options, then go to the Disk Cleanup tab and click delete files. Try on another servers/workstation where Exchange Management Tools installed to see if same result if not then it is particular server issue.

Clarify: when you click the Disconnected Mailbox from EMC, you got the error Resolution: This issue was most likely caused by some of the disconnected mailboxes having multiple duplicate objects, or corrupted somehow. Prove that it is the cause: 1. Dismount the store that disconnected mailbox stayed before 2. Try to open Disconnected Mailbox Notes: If you can open, follow the steps below to resolve issue: 3. Remount store, Go to EMS, run clean-mailboxdatabase to it http://technet.microsoft.com/en-us/library/bb124076(EXCHG.80).aspx 4. Refresh EMC 5. Now you can open Disconnected Mailbox and connect mailbox to AD user To resolve the issue, there's also another way. You can set the Deleted Mailbox retention time to 0 days, and forced Online Maintenance to run to purge all the deleted mailboxes: 1. Go to EMC->Server Configuration->Mailbox->found the store that disconnected mailbox stayed before and right-click it, choose Properties 2. Limits tab->set Keep deleted mailboxes for to 0 3. General tab->set Maintenance Schedule to run 4. Dismount and Remount store again and waiting, maintenance will start within 15 mins 5. After that, you can open Disconnected Mailbox

Hi, hoong, does it work for you? How's the issue?

still in testing

See

i was unable to test it at the moment,coz it still in the live,plus backup job run yet. hope tonight i can test it.

That's OK. Not need rush

Hi, Hoong, I assume your question has been answered, and I'd like to change the status to "Marked as answer", please feel free to post here if you have any update

your solution might work, coz when i dismount mailbox DB; and i can connect the DB in the disconnected mailbox without any error(of coz is show the mailbox DB has been dismount) but i can't remember which mailbox i had disconnected before. can you advice me what commmand can list down the mailbox has been disconnedcted ? thanks

Sure Get-MailboxStatistics | where { $_.DisconnectDate -ne $null } | fl DisplayName,MailboxGuid > c:\disconnectedmailbox

isseem not good after export the file, it showing 0 kb it look like exchange unable show the history. any suggestion ? thanks

Suggest you use second method to solve the issue, you may use latest backup to restore user's mailbox