How to reduce a huge .stm file?

Hi Experts,

I'm running Exchange 2003 Standard.  Priv.edb is about 32GB.  Priv.stm 'was' probably a gig or so, maybe a bit more or less but definately small.  Over the weekend, one of our applications went mad and decided to send millions of emails.  Now my .stm file is 37GB!!  So I'd like to reduce it.

So far I've tried to move the mailbox (which shows as 32GB in ESM) to a backup exchange server.  The move ran for 46 hours before it failed coz the other server ran out of disk space when that priv.edb got to about 46GB (bigger than the 37GB stm file).  One thing I noitced in the 'move mailbox' wizard is that it would count up to approx 64,000 items then go back and start counting from zero again.  I was hoping it was moving 64,000 emails at a time but now I think it may have been trying to move the first 64,000 emails over and over again.
I've also tried to open the mailbox in Outlook but so far that's been hanging for 24 hours.

Does anyone have any ideas of anything else I can try?

oh, I also tried to exmerge the emails out but that stopped (and hung) after half a gig.
LVL 10
Who is Participating?
kieran_bConnect With a Mentor Commented:
>>If I delete the mailbox, would that get rid of the emails (or the bodies of the emails) that are stuck in the stm file?

Yes, it would.

However, the database will not shrink until you defrag it or move all the users to a new database and delete it.
Which mailbox is it?  Can you just delete the contents?
DarylxAuthor Commented:
I was wondering if I could just delete the mailbox and recreate another one.  I thought about deleting the actual contents which is why I've tried to open the mailbox with outlook, but that's just been hanging for 24 hours now.
If I delete the mailbox, would that get rid of the emails (or the bodies of the emails) that are stuck in the stm file?
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

Paul SolovyovskyConnect With a Mentor Senior IT AdvisorCommented:
1.  Make sure you're running SP2 of Exchange and your mail store is set to a larger mail store size than default which is 16GB in SP1 and 18GB in SP2.  This is only if you're trying to move it.  

I would delete mailbox and restore from backup the day before if possible, this will get you to a state without the large mailbox and to where you were before this occured
Justin DurrantConnect With a Mentor Sr. Engineer - Windows Server/VirtualizationCommented:
You could also create a new store and move the users from the old stores into the new ones. This will commit anything in the STM file and also defrag the database.
DarylxAuthor Commented:
Thanks guys.  I deleted the mailbox and ran an offilne defrag.

The edb file is now down to 25GB from 37GB.
The stm file is now down to 2.5GB from 38GB.
That's reduced it all by 47.5GB, amazing :-)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.