Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Growing Database

Posted on 2006-03-27
18
Medium Priority
?
1,322 Views
Last Modified: 2007-12-19
I am watching my Exchange database grow insanely high. Even today I have used up to 300MBs of storage I know we do not move that much mail internally in a day.  I have also removed and archived several email boxes.  I have not seen the database shrink any.  

What utilities can I use to crunch down my database.  I'm using Exchange 2003 with no service packs

Help.
0
Comment
Question by:ChrisTHall
  • 12
  • 6
18 Comments
 

Author Comment

by:ChrisTHall
ID: 16305493
I know I need to run the ESEUTIL, but it does not find it when I run it from a command line.  I can find it when I search the file structure, but it won't start from a command prompt
0
 

Author Comment

by:ChrisTHall
ID: 16305570
ok...in the message store properties is the maintainence section.  How can I tell it to start the compacting now...instead of waiting til midnight or something?
0
 

Author Comment

by:ChrisTHall
ID: 16305696
from reading other posts and such about the eseutil, does it mean I have to take the exchange server offline to recover the storage space?  I saw where my ese utility is running at night, but that apparently is only doing a defrag.  Last night it got interrupted.  I am wondering why it isn't crunching the database each night?

0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

 

Author Comment

by:ChrisTHall
ID: 16305963
Can I run the eseutil integrity check while the database is in use?   Am beginning to think I am going to have to take the server offline and run the eseutil from a command prompt to get it to defrag and crunch the database using a mapped drive to another storage place.

0
 

Author Comment

by:ChrisTHall
ID: 16306075
I found this on one of the other posts about this question, will these steps work for me?

Actually this is what you would do:
1. Create a folder on the external drive, lets call it EXCHDB.
2. Stop the Information Store service on the Exchange server.
3. COPY the PRIV.EDB, PUB.EDB, ESE.DLL, and ESEUTIL.EXE files from the Exchange server to the EXCHDB folder.
4. Open a command prompt. Change directory to the EXCHDB folder on the external drive.
5. Run the following:
ESEUTIL /D PRIV.EDB
ESEUTIL /D /PUB.EDB
6. While step 5 is running rename the MDBDATA folder on ALL drives of the Exchange server to MDBDATA.OLD. Create a new MDBDATA folder wherever you renamed one.
7. If you are lacking space, then move the MDBDATA.OLD folders to a secure location on another machine. This way if something happens you can always get back to where you started from.
8. After step 5 completes you can copy the PRIV.EDB and PUB.EDB back into the appropriate MDBDATA folder on the Exchange server.
9. Start the Information Store service. You may receive a -1011 pop-up error. If so open a command prompt and change into the EXCHSRVR\BIN folder. Run the following:
ISINTEG -PATCH
10. Start the Information Store service.
0
 
LVL 27

Accepted Solution

by:
Exchange_Admin earned 2000 total points
ID: 16306273
Those steps in your last post are for Exchange 5.5. The process for Exchange 2003 is similar. Check the MS Knowledge Base for an article on how to run ESEUTIL on another server that does not have Exchange installed on it. This is only to be used if you don't have enough space on your Exchange server.

1. You must dismount the stores to run ESEUTIL /D against them.
2. Free space on a drive on the server must be equal or greater than 110% of the size of the databases being defraged. The size of the database is equal to the EDB+the STM files.
3. "but it does not find it when I run it from a command line"
This is because it is in the program files/exchsrvr/bin folder and usually this folder is not included in the Path variable.
4. The Exchange database will never reduce in size unless you run ESEUTIL /D.
5. After you have deleted data from the mailboxes, you must allow the online maintenance to complete AND the Deleted Item Retention time to expire before you will be able to recover the space with ESEUTIL /D.
6. Look for a recent event id 1221 in the application log. There should be one for the mailbox store and one for the public folder store. The value listed in this ID is the amount of space that will be recovered with ESEUTIL /D.
0
 

Author Comment

by:ChrisTHall
ID: 16306298
so where do I set the deleted item retention parameter so that it will dump the data sooner?
0
 
LVL 27

Expert Comment

by:Exchange_Admin
ID: 16306311
Go to the properties of the mailbox store in the Exchange System Manager.
0
 

Author Comment

by:ChrisTHall
ID: 16306316
so if I set this to 0 days....it should dump them tonight....and then I can change it back?
0
 
LVL 27

Expert Comment

by:Exchange_Admin
ID: 16306342
You can change it back after the online maintenance completes.
0
 

Author Comment

by:ChrisTHall
ID: 16306361
Thanks...I would like to recap real quick to make sure I am on the same page.

I have gone in to the mailbox store and set deleted mailboxes to 0 days.  That should remove them tonight and the defrag should run tonight also.  This will or will not free up space from the stores?

if not then I need to take the email server offline and use the ESEUTIL program after reading using on a different server and that will compact the space.  This has to be an offline process right?

Thanks for all your help.
0
 

Author Comment

by:ChrisTHall
ID: 16306392
on an aside....how fast does the store suck up disk space?  I just freed up about a gig of storage by moving some log files off...and in the 2 hours that I did that it has use up half of that space for something. I know I did not move or have come into my system 500MB of mail?

0
 
LVL 27

Expert Comment

by:Exchange_Admin
ID: 16306432
You need to determine what you are trying to resolve.
Are your space issues related to .log files being generated by Exchange or just to physical size of the database?
If it is log files how often are you backing up your Exchange server? When a daily ONLINE Exchange backup is made then the log files that have been committed are purged from the disk. If you are doing individual mailbox backups, also known as brick level backups (BLB) then this will not purge the log files.

In answer to your questions:
"This will or will not free up space from the stores?"
It will allow physical space to be recovered by running ESEUTIL /D. Look for the event id 1221.
I call it online maintenance, some other call it online defrag. Either way it will NEVER physically reduce the size of the database. There is an article in the MS Knowledge Base that details what happens during online maintenance.

"if not then I need to take the email server offline and use the ESEUTIL program after reading using on a different server and that will compact the space.  This has to be an offline process right?"
This is correct.
0
 

Author Comment

by:ChrisTHall
ID: 16306734
well There are a huge number of log files in the MBDdata folder...I do a backup each night of the exchange server doing a brick level backup using veritas.  Should I change the backup to do a different way? the files only go back to the beginning of february. but there are about 3k of them.

Can I move them off to another storage location?  my priv db is 24GB and the stm file is 12GB.

So, what do you sugest I should work for?
0
 

Author Comment

by:ChrisTHall
ID: 16307021
On veritas I can not do a brick level and an information backup.  I have to do one or the other, so if i backup just the information store, which should remove the log files, right? Can I still recover individual mailboxes and emails?

Thanks again for all your help.
0
 
LVL 27

Expert Comment

by:Exchange_Admin
ID: 16307433
" I have to do one or the other, so if i backup just the information store, which should remove the log files, right? Can I still recover individual mailboxes and emails?"
With Exchange 2003 there is really no reason to run BLB's. Just back up the information store.

I will not give you the direct link but will point you to the MS Knowledge Base. Search for Exchange 2003 recovery storage group. I say this because you will retain more if you have to do the work as opposed to someone just telling you the answer.
There is a wealth of information in the knowledge base.

By properly configuring your deleted item retention, teaching your users and/or help desk how to recover their own deleted items, you can greatly reduce the need to restore individual mailboxes. Then if by some chance the deleted item retention time has passed, make use of the recovery storage group feature to recover what is needed.
0
 

Author Comment

by:ChrisTHall
ID: 16307450
I'll look into it...as I get time...wish I was a network admin 100% of the time...lol

So, it is ok if I move off the older log files from the mdbdata folder?  
0
 
LVL 27

Expert Comment

by:Exchange_Admin
ID: 16307505
Sure if you want to take the chance of corrupting your databases.
Seriously, no offense intended, but based on the questions you have been asking it would probably not be a good idea. You can corrupt your databases if you move the wrong files.
Just run a backup of your Exchange Information store using Veritas or NT backup. Why make the solution more difficult than it has to be.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Upgrading from older Exchange server to the latest Exchange server can be tiresome, error-prone and risky, without being a seasoned exchange server administrators. It can become even problematic if you're an organization that runs on tight timeline…
There are literally thousands of Exchange recovery applications out there. So how do you end up picking one that’s ideal for your business & purpose? By carefully scouting the product’s features, the benefits it offers you, & reading ample reviews f…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…
Suggested Courses

577 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