what are the steps needed to perform a defrag of the exchange 03 database using Eseutil?

what are the steps needed to perform a defrag of the exchange 03 database using Eseutil?

the size of our edb and stm files are 19.5GB combined, how can i reduce this? the size of all mailboxes are approx 15GB. once i dismount the mailbox store, what steps do i need to take to reduce the size, included remounting the database?
LVL 3
jasonfarmerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TWBitCommented:
Can you check event ID 1221 first? This will tell you how much you will recover.  For 4.5 GB, it's not worth it to me. You'll also need 25GB free to run it.
0
jasonfarmerAuthor Commented:
event id 1221

The database "First Storage Group\Public Folder Store (SBS2003)" has 5 megabytes of free space after online defragmentation has terminated.

dont i need to get this under 18GB so the exchange services dont stop during maintenance? every morning i have to manuall restart the exchange services becuase i am over the 18GB limit.
0
Hypercat (Deb)Commented:
First, Microsoft recommends strongly AGAINST defragging an Exchange database unless there are compelling reasons to do so.  Mostly, online defragmentation will reclaim as much space as possible so that you don't need to do an offline defrag.  If your Exchange server is properly configured, it should be running an online defrag at least once a day by default.

When you look at the size of your database compared to the size of the actual individual mailboxes, you will also see a difference.   This difference is caused by things like deleted item and deleted mailbox retention policies, as well as fragmentation.  It is highly unlikely that doing an offline defrag will regain 4.5GB of space.  Unless the hard drive where your email database is stored is extremely strapped for space, it's probably more trouble than it's worth to do the offline defrag.

Taking all that into consideration, here is an MS knowledgebase article on how to do an offline defrag of the Exchange databases:

http://support.microsoft.com/kb/192185/en-us

IMPORTANT:  Please note an important caveat that is buried somewhere in this article. In order to do an offline defrag of the Exchange database, your hard drive must have free space equal to 110% of the size of the database you are trying to defrag.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Hypercat (Deb)Commented:
You posted your database size limit question while I was posting my first answer.  If you are running Exchange SP2, which you should be, the database size limit has been eliminated.  If you're not yet on SP2, then you should download and install it.  

Here's info on how to edit the default database size limits after installing SP2:

http://support.microsoft.com/kb/912375/en-us
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jasonfarmerAuthor Commented:
this is what i got prior to the issues starting.. id 9688

Exchange store 'First Storage Group\Mailbox Store (SBS2003)': The logical size of this database (the logical size equals the physical size of the .edb file and the .stm file minus the logical free space in each) is 17 GB. This database size is approaching the size limit of 18 GB.

If the logical database size exceeds the maximum size limit, it will be dismounted on a regular basis.
0
TWBitCommented:
Let's not confuse Pub with Priv.  Review the steps to increase Pub, if you haven't yet done so. http://support.microsoft.com/kb/912375

How much is free in your Priv store?
0
jasonfarmerAuthor Commented:
what steps do i need to take to install exchange sp2 on a small business server 2003 os?
0
Hypercat (Deb)Commented:
Same as any server - just download the service pack executable from the Microsoft downloads website and then run it.  You do not need to dismount the databases or anything special, although you do need to be aware that the Exchange services will be temporarily stopped while the SP installation is running.
0
TWBitCommented:
>>  If you are running Exchange SP2, which you should be, the database size limit has been eliminated

There is a limit - 75GB.  But it's a huge increase over 18GB pre SP2
0
Hypercat (Deb)Commented:
Yes, you are correct, TWBit.  That 75GB is the same as the old Exchange Enterprise edition size limit, and so to be brief and uncomplicated, I just didn't mention it.
0
jasonfarmerAuthor Commented:
if i remember correcly, when i tried to install exchange sp2 it said i need to install windows 2003 sp2. is this correct? do i need to do both?
0
TWBitCommented:
0
jasonfarmerAuthor Commented:
i'm downloading exchange sp2 now. i'll run the install tonight and change the registry indicated here:

http://support.microsoft.com/kb/912375/en-us

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Exchange

From novice to tech pro — start learning today.