Database repair questions

Posted on 2011-03-08
Last Modified: 2012-05-11

I am testing out eseutil /p in my Exchange 2007 lab and had some further questions just in case I am ever forced to use this.

1. If I had a 100GB database, is there any way to work out how long the /p, the /d, and the isinteg fixes will take individually? Or does this all depend on the damage to the DB, the server resources etc?

2. When running both the /p and /d, is there anyway to find out how the progress is going or if it's hung?

3.  If I'm running out of space on the drive for /p, I know I can use /t to specify the location of the temp database ESEutil uses,can this be used for both ESEUtil /p *and* ESEUtil /d? And is this the location of the TEMP database only, so nothing actually ends up there, the file in this location automatically is copied back?

4. If I don't have any spare space on the server at all, is it advisable to use /t for both /p and /d to point to a network share?
Question by:Joe_Budden

Accepted Solution

Timothy McCartney earned 167 total points
ID: 35069003
1. The damage of the database definitely has an affect on how long each scan will take, so predicting the actual time is a little difficult.
2. I generally check this through the Performance Monitor to see if the utility is still active.
3. Yes, you can create a temporary location on a separate hard drive in the event that your database is on a disk that is running low on space. This can be done for both switches.
4. I would recommend using a local disk to use the /t switch for. The network share may drastically increase the time of which it takes to perform said functions.

Expert Comment

by:Timothy McCartney
ID: 35069011
LVL 41

Assisted Solution

Amit earned 167 total points
ID: 35069105
Normal thumb rule is 3-4GB Per hour. It can vary also according to hardware and what time you are running it. If during weekend, it can be fast. Always disable the Antivirus, whenever you are using eseutil command line.
LVL 17

Assisted Solution

lucid8 earned 166 total points
ID: 35083721
1. as the others have said its really all relative to, the size of the DB the damage in the DB, the system you are running on, i.e. CPU, memory, Disk I/O etc

2. Basically be really patient because sometimes a process you think is dead is just taking its time since some operations happen in memory and others to disk.  

3. Yes this can be done and sometimes its preferable to do on another system, i.e. if the main servers disk system is suspect then the last thing you want to do is to run a /D or /P against the database since these commands put a heavy stress on the disk and in short you could end up doing more damage than good.  

4. You can point to a network share if its your only resort but realize that the process is going to A. take a lot longer to run and B. if you lose connectivity mid process you will have to start over

5. Whichever process you run be sure to NEVER do it against your only copy, i.e. keep a master safe and untouched by utilities and then only work against a copy.

6. Lastly as referenced above you want to find out why this happened and best place to start looking is your event logs to see how long its been going on and get the issue corrected BEFORE bringing the database back online.  NOTE: If you made recent changed those could be the culprit as well so undo them i.e. adding memory, firmware updates, HD updates etc

Think I covered everything but let me know if I missed anything
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.


Author Comment

ID: 35086474
Thanks everyone for their input.

Regarding this great point here:

"5. Whichever process you run be sure to NEVER do it against your only copy, i.e. keep a master safe and untouched by utilities and then only work against a copy."

How would I make a copy of the EDB file and then run against that?
LVL 17

Expert Comment

ID: 35087456
After taking the database offline you could

1.  do a simple file COPY of the EDB files to an alternate location, disk, directory etc
2. or if its a rather large file and you could use "Eseutil  /Y" to do the copy

Expert Comment

by:Timothy McCartney
ID: 35087504
what @lucid8 said.

I just dismount the mailbox store, then use the simply "right-click > copy - right-click paste" command to the EDB files. This way if one of the utilities fails, you can always revert back to the original.
LVL 17

Expert Comment

ID: 35232672
Thanks for the points

Featured Post

The problems with reply email signatures

Do you wish that you could place an email signature under a reply? Well, unfortunately, you can't. That great Exchange/Office 365 signature you've created will just appear at the bottom of an email chain. What a pain! Is there really no way to solve this? Well, there might be...

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
In this video we show how to create an email address policy in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.:  First we need to log into the Exchange Admin Center. Navigate to the Mail Flow…
This video discusses moving either the default database or any database to a new volume.

948 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now