We help IT Professionals succeed at work.

Unable to delete items after Database Corruption

GilesB
GilesB asked
on
Medium Priority
447 Views
Last Modified: 2012-06-27
We have had a problem that started with being unable to open attachments on emails that had been received in the last few days.  We ran some database utilities to try and correct this, however now these emails cannot be opened at all.  We cannot delete or move them as we get the following error, "The item could not be deleted, it has been moved or access is denied".
If you try and open the email you get "Can't open item".
We are logged on as administrator.
Does anyone know how to delete these emails.
Comment
Watch Question

Commented:
hi gilesB ,

it looks like you have broken connections between your
IS and DS first i would like to know if this issue occur
on all database (i.e. Public folders , other mailbox)?

Amnon.



Author

Commented:
This only occurs in the local mailboxes, i.e. the Public folders all appear to be ok.

Author

Commented:
This only occurs in the local mailboxes, i.e. the Public folders all appear to be ok.

Commented:
i see

first of all this is a good start point:
http://www.microsoft.com/Exchange/using/tips/DB_Corrupt.asp
i can recommend you to put the server in offline mode
and try to recover the Directory database or even to
examin him and look for inconsistency by using the
esutil you can find in c:\winnt\system32 that for IS and DS
work with the util very carefully !!!
1st use the recovery option and defrag and only
if you dont have any
choice you can use the repair option that can take some time (depend your database size) and in some case lose data
any way before you even come near to the machine you must
have a full backup (i sure you know that already)

hope i can help

Amnon.

Author

Commented:
We have already used eseutil.exe. We first discovered that some attachments would not open. So we found out about eseutil.exe in an O'Reilly exchange book that we have. The book had a misprint stating /R as the desructive mode and /P as non-destructive.

So we accidentally ran eseutil /P /ds /o (and /ispub, /ispriv) first. This recovered some of the lost attachments but destroyed some of the emails.

Since then we have tried /R /D /P modes and isinteg. but none of it has worked.

I guess that the first eseutil /P deleted some email in order to restore database integrity. The problem is that we can't delete the damaged emails for outlook.

Any more ideas?
Thanks
Commented:
1) maybe stupid idea but...who knows
try to download your mail to client pst/ost file and then
try to repair . this one will clean the "Badmail" you have
and then try to recover from backup i mean you can "play" with your mail items but not we the exchange server
2) we already talk about restore from backup only mail items you want and not all the mailboxs or database
(what kind of backup util you use ???)
3) fully restore of the database IS and DS but that more radical action but again you have radical situation.

what you think about that ?

Amnon.

Author

Commented:
Thanks for the suggestions,

1) We have already tried this, but the bad emails wouldn't export. And neither would a lot of the good ones (about 10% would export and 90% wouldn't).

2) Our backup system had failed to back up the edb file :(

3) I think this is the best option at the moment.

Thanks again for your help.

Commented:
After running an eseutil /p try running the isinteg -fix -test alltests (I think it is) on the store. The reason for this is that eseutil will fix the physical corruption and isinteg will fix the logical corruption so if you just run eseutil without running isinteg then the corrupted messages will be removed from the store but there will still be references to these and users will try and open the mails and experience issues. Also run isinteg until there are 0 warnings, 0 errors and 0 fixes.

Paul
You have 16 open questions today, some of which date back to the year 2000, all need your attention.  ADMINISTRATION WILL BE CONTACTING YOU SHORTLY.  Moderators Computer101, Netminder, Mindphaser or I will return to finalize these as soon as possible if after 7 days no response by the Asker.  EXPERTS-->  please post closing recommendations before that time.

Below are your open questions as of today.  Questions which have been inactive for 21 days or longer are considered to be abandoned and for those, your options are:
1. Accept a Comment As Answer (use the button next to the Expert's name).
2. Close the question if the information was not useful to you, but may help others. You must tell the participants why you wish to do this, and allow for Expert response.  This choice will include a refund to you, and will move this question to our PAQ (Previously Asked Question) database.  If you found information outside this question thread, please add it.
3. Ask Community Support to help split points between participating experts, or just comment here with details and we'll respond with the process.
4. Delete the question (if it has no potential value for others).
   --> Post comments for expert of your intention to delete and why
   --> YOU CANNOT DELETE A QUESTION with comments; special handling by a Moderator is required.

For special handling needs, please post a zero point question in the link below and include the URL (question QID/link) that it regards with details.
http://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
 
Please click this link for Help Desk, Guidelines/Member Agreement and the Question/Answer process.  http://www.experts-exchange.com/jsp/cmtyHelpDesk.jsp

Click you Member Profile to view your question history and please keep them updated. If you are a KnowledgePro user, use the Power Search option to find them.  

Questions which are LOCKED with a Proposed Answer but do not help you, should be rejected with comments added.  When you grade the question less than an A, please comment as to why.  This helps all involved, as well as others who may access this item in the future.  PLEASE DO NOT AWARD POINTS TO ME.

To view your open questions, please click the following link(s) and keep them all current with updates.
http://www.experts-exchange.com/questions/Q.11552798.html
http://www.experts-exchange.com/questions/Q.11563418.html
http://www.experts-exchange.com/questions/Q.11648078.html
http://www.experts-exchange.com/questions/Q.20126111.html
http://www.experts-exchange.com/questions/Q.20127045.html
http://www.experts-exchange.com/questions/Q.20127782.html
http://www.experts-exchange.com/questions/Q.20130915.html
http://www.experts-exchange.com/questions/Q.20240934.html
http://www.experts-exchange.com/questions/Q.20241790.html
http://www.experts-exchange.com/questions/Q.20243441.html
http://www.experts-exchange.com/questions/Q.20245798.html
http://www.experts-exchange.com/questions/Q.20245796.html
http://www.experts-exchange.com/questions/Q.20265935.html
http://www.experts-exchange.com/questions/Q.20272321.html
http://www.experts-exchange.com/questions/Q.20291423.html

To view your locked questions, please click the following link(s) and evaluate the proposed answer.
http://www.experts-exchange.com/questions/Q.20259387.html

*****  E X P E R T S    P L E A S E  ******  Leave your closing recommendations.
If you are interested in the cleanup effort, please click this link
http://www.experts-exchange.com/jsp/qManageQuestion.jsp?ta=commspt&qid=20274643 
------> POINTS FOR EXPERTS awaiting comments are listed in the links below
http://www.experts-exchange.com/commspt/Q.20277028.html (Part 1)
http://www.experts-exchange.com/jsp/qShow.jsp?ta=commspt&qid=20295853 (Part 2)
 
Moderators will finalize this question if in @7 days Asker has not responded.  This will be moved to the PAQ (Previously Asked Questions) at zero points, deleted or awarded.
 
Thanks everyone.
Moondancer
Moderator @ Experts Exchange
Question abandoned; force-accepted.

Netminder
CS Moderator

Explore More ContentExplore courses, solutions, and other research materials related to this topic.