Solved

How to reduce a huge .stm file?

Posted on 2008-10-02
6
2,979 Views
Last Modified: 2012-06-27
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.
0
Comment
Question by:Darylx
6 Comments
 
LVL 25

Expert Comment

by:kieran_b
ID: 22622179
Which mailbox is it?  Can you just delete the contents?
0
 
LVL 10

Author Comment

by:Darylx
ID: 22622211
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?
0
 
LVL 42

Assisted Solution

by:paulsolov
paulsolov earned 100 total points
ID: 22622216
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
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
LVL 25

Accepted Solution

by:
kieran_b earned 300 total points
ID: 22622251
>>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.
0
 
LVL 23

Assisted Solution

by:Justin Durrant
Justin Durrant earned 100 total points
ID: 22623360
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.
0
 
LVL 10

Author Comment

by:Darylx
ID: 22709432
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 :-)
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
In this video we show how to create a Distribution Group 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 Recipients >>…
In this video we show how to create a mailbox database 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 Servers >> Data…

813 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

9 Experts available now in Live!

Get 1:1 Help Now