Question

Huge STM file and how do I shrink it?

Asked by: munozm

I have an Exchange 2003 SP2 bridge-head server that I use as a relay server for my internal applications, Sun boxes etc. What happened is that one of the Sun boxes had been queueing up messages from a cron job for at least 6 months (I don't have any idea how long) and decided to relay the messages all at once. When it did, the STM file grew from 600MB to 30GB, filled up the disk and crashed the server.

My question is, will an offline defrag (eseutil) shrink the STM file back to what it was?

This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

  • Plus...
  • 30 Day FREE access, no risk, no obligation
  • Collaborate with the world's top tech experts
  • Unlimited access to our exclusive solution database
  • Never be left without tech help again

Subscribe Now

Asked On
2007-07-06 at 06:14:13ID22679217
Tags

stm

,

file

,

shrink

Topic

Exchange Email Server

Participating Experts
2
Points
0
Comments
7

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

  • "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
  • "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
  • "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.

Screenshot of Experts Exchange Knowledgebase

Need individual assistance?

Our experts are ready to help.

If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.

Screenshot of Experts Exchange Knowledgebase

Want to learn from the best?

Read articles from industry experts.

Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.

Screenshot of an Article

Working on a long term project?

Store your work and research.

Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.

Screenshot of Experts Exchange Knowledgebase

Access the answers to your technology questions today.

Subscribe Now

30-day free trial. Register in 60 seconds.

What Makes Experts Exchange Unique?

Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Trusted by the world's most respected brands.

image of each brand's logo

Faithfully serving IT professionals since 1996.

Experts Exchange Logo

Try it out and discover for yourself.

Subscribe Now

30-day free trial. Register in 60 seconds.

Related Solutions

  1. exchange 2003 .stm file
    can someone explain in plain english what happens in the exchange .stm file i have about 1 gb of free white space in my priv.edb file the .edb file is not growing as expected because of the white space the .stm file grows just about everry day at this rate i will reach the 16...
  2. Exchange .stm size?
    Running Exchange 2000 sp3 Our .edb is 4GB and the .stm is 12.9GB Why is the .stm so much larger and how can we make it smaller. Have already run an online defrag and offline defrag.
  3. STM File won't shrink in exchange 2000
    My edb database file is under 2.65 GB but my STM is 14.1GB I have dismounted the store and run an offline defragment but it stayed at 0% for over 2.5hrs and I'm not sure if it was doing anything so I have cancelled it and have remounted the store. There are no real messag...
  4. priv1.edb won't shrink after eseutil help
    Hiya, We have an exchange 2000 server which reached the 16GB limit and unmounted. Ok so I ran an offline defrag and it shrunk it to 15.7GB. So I double checked in System Manager \mailboxes and looked at the sizes & totaled them up. And it only came to about 2-3GB of mail...
  5. Eseutil useage of /s option to set .stm path
    Hi there We have an exchange 2003 database we need to defrag with eseutil /d. The streaming file sits on a different drive letter. Do i use the /s switch to set the path to the .stm file, or will it figure it out by itself?? Jafar54
  6. Exchange Defrag STM file online offline
    I have a big stm file, how do I schrink this file. I don't think the offline defrag schrink the file enough. Is there a way where you can see what's in the file? Another question. Is it possbile to schrink the .edb and .stm files online or do you have to make an offline defrag?

Free Tech Articles

  1. WARNING: 5 Reasons why you should NEVER fix a computer for free.
    It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
  2. SCCM OSD Basic troubleshooting
    SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
  3. Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
    This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
  4. Create a Win7 Gadget
    This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
  5. Outlook continually prompting for username and password
    There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
  6. Backup Exchange 2010 Information Store using Windows Backup
    There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...

Cloud Class Webinars

  1. Avoiding Bugs in Microsoft Access
    Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
  2. Top 10 Best New Features in Visio 2010
    Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
  3. IT Consultant Business Secrets Revealed
    Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
  4. Disaster Recovery and Business Continuity
    Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
  5. Organize Your Visio Diagrams with Containers and Lists
    Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
  6. How to Us Objects, Properties, Events and Methods in Microsoft Access
    Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...

Join the Community

Give a Little. Get a Lot.

Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.

Join the Community

Answers

 

by: mass2612Posted on 2007-07-06 at 06:25:42ID: 19431563

Hi,
The STM file holds message info that was submitted by non-mapi clients. A defrag should help clean up any empty pages and indexes but only if there are empty ones available. Are you seeing any events in the logs to do with this? What does the event 1221 show as this will show the amount of recoverable space in the database. You will need to let the online defrag complete to get this info.

The sTM file does contain user data so don't delete it or anything (some people have in the past).

 

by: munozmPosted on 2007-07-06 at 06:48:47ID: 19431727

The online defrag is showing that there is a small amount of free space but does this address the free space in the EDB file or STM file?

 

by: mass2612Posted on 2007-07-06 at 07:07:04ID: 19431847

Yeah sorry not sure. As a guess I'd say that the event does not report the space available in the STM file. The defrag would defrag both the EDB and STM but would be a bugger to take the DB offline for nothing. You could take a copy of the files and do an offline defrag on a client machine to test to see if the space can be re-claimed. You would need to take the database down long enough to do a flat file copy to a workstation and then restart the database for user access.

You can then run a defrag (you'll need to install the tools and have enough disk space i.e. 110% of the datbase size) and run the defrag as this can take a while and no point having the database down if this won't fix it. If it does then you can schedule an outage for the live defrag. Before trying anything i'd be backing up.

How to Defrag an EDB File on a Non-Exchange Server - article is old but concepts are the same
http://support.microsoft.com/kb/163627

Defragmenting your Exchange Database
http://www.msexchange.org/tutorials/Defragmenting-Exchange-Database.html

 

by: munozmPosted on 2007-07-06 at 09:17:24ID: 19432879

I just got off of the phone with Microsoft and they said that I will need to create new stores 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. They also said I can do this online with users accessing their mailboxes. I will be moving about 2300 users...anybody ever move a large number of users while they were accessing their mailboxes?

 

by: mass2612Posted on 2007-07-06 at 14:22:58ID: 19435164

Do you have all 2300 users in the one database? You shold only need to move the users ni the affected database I would think but their the experts ....

With the weekend coming on I would do them in groups of users maybe 100 depending on your hardware and average mailbox size. Once your user load on the mailbox goes down you could increase the number of mailboxes.

 

by: realitybytesPosted on 2008-01-05 at 19:46:14ID: 20592409

munozm, i have the same problem, and i was wondering if you could share with me the results of what you did, and provide a little more detail as to how you went about it. specifically, how do i create a new mail store, and move the mailboxes from the old store into the new one? and more importantly, how do i accomplish this without taking exchange offline?

 

by: munozmPosted on 2008-01-07 at 09:39:16ID: 20601225

realitybytes,

This is your best bet for creating the new stores:
http://support.microsoft.com/kb/821748/en-us

To move the users just select them in AD Users and Computers, right-click, select Exchange Tasks and follow the steps for moving the users...

20120131-EE-VQP-002

3 Ways to Join

30-Day Free Trial

The Experts

98% positive feedback on 31,087 answers since March 2000. angeliii is a Microsoft Most Valuable Professional for his work with MS SQL Server & Develoment.

He has also proven his knowledge of Visual Basic Programming, PHP Scripting and Oracle Databases.

The Experts

97% positive feedback on 10,752 answers since July 2000. lrmoore has more than 18 years experience in the networking industry.

The six-time Mircosoft MVPs specialties include firewalls, virtual private networking, and network management.

Testimonials

"...and excellent source for support... Kind of like having your very own IT dept." Electriciansnet

Testimonials

"I was apprehensive at signing up at first. However... it has already made my life as an IT administrator much easier." JaCrews

Testimonials

"WOW! You guys have great, active, and knowledgeable people on here." moore50

Business Clients

Business Clients

In the Press

"If you’ve got a question... Experts Exchange can supply an answer.”

In the Press

"...an invaluable aid for both IT professionals and those who require tech support."

In the Press

"where IT professionals provide quick answers on just about any topic"

Business Account Plans

Loading Advertisement...