How to Clear out Move Archive List
Hi Folks,
I have a Customer who is moving some Users to a new EV Site with Move Archive.
For almost all users this procedure is working fine but we had 1 User whose Mailbox was recreated during the Move Process.
The Customer decided to Export the Users Archive to PST, import it to the newly created Archive for the new Mailbox and then delete the User-Entry in the Move Archive Status list.
Too bad the Move was stuck in Step 2 of 5 (waiting to update Shortcut) and therefore the Entry can not be stopped or deleted. I was searching through the EV-Database to find out where that information is stored but did not find anything.
The customer could live with that 1 Entry that will be stuck forever but is there a way to get that cleanded out?
Thanks for any suggestions.
Holger
Comments 2 Comments • Jump to latest comment
you would have to delete the users entry from SubTask, ArchiveHistory and ArchiveMoveHistory tables
Then on the site the user is going to, go to the users ExhcangeMailboxEntry record, look at the MoveArchiveShortcutsSubtask column, it will have an ID there, note down the ID
then do a DELETE FROM SubTask WHERE SubTaskEntryId = 'value from EME'
Thanks a lot! Looks a lot nicer now!
If you delete it manually you can delete the Subtask, then the ArchiveMoveHistory then ArchiveHistory (the last 2 have foreign references to it so you need to keep the order right)
------
Holger Mundt | I.Tresor GmbH & Co. KG | Germany | http://www.i-tresor.de
Would you like to reply?
Login or Register to post your comment.