[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 589
  • Last Modified:

Database size conisderably larger than total mailbox size after offline defrag

We are running Exchange on a SBS 2003 server.  We moved about 5 GB of a user's archives to an offline store so we could shrink the datastore size so it can be pushed off-site for backup purposes.  The total file stores before running eseutil /d was a little over 10 GB.  After running the defrag we only gained a couple hundred MB of space.  When I look at the total of all the mailbox sizes in the System Manager it only adds up to about 4.5 GB but my priv1.edb and priv1.stm together equal over 10 GB still and event viewer is reporting only 113 MB of free space available.   What could account for the additional 5.5 GB of size?
0
Deltavcomm
Asked:
Deltavcomm
1 Solution
 
redseatechnologiesCommented:
Hi Deltavcomm,

Deleted Item Retention time.

You moved the files, but exchange is hanging onto them for a while first (7 days is the default)

You can see it here -> http://www.computerperformance.co.uk/exchange2003/exchange2003_recovery_deleted_item.htm

Set it to 0 days, wait for online defragmentation (or force it) then run an offline defrag and you will get your space back

Hope that helps,

-red
0
 
Exchange_AdminCommented:
What is your deleted item retention time set to?

This is how it works:
1. You delete data from the the database. This data is assigned a tombstone.
2. By default every night the online maintenance runs. This will compare the tombstones to the deleted item retention time. When the tombstones have expired then this space is marked as "white space" and will be availiable to be reused by Exchange or recovered by running an offline defrag.

Look for an event id 1221 in your event viewer application log. These events are logged when the online maintenance completes. There are entries for both the public and mailbox stores. The value listed in the event is the amount of space you will recover when you run an offline defrag.
Hope this helps.
0
 
Exchange_AdminCommented:
Red,
You beat me to the punch. That is what I get for being longwinded.
lol
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
redseatechnologiesCommented:
At least we both managed to beat the google monkeys :)

That is all that counts!
0
 
robjeevesCommented:
<Monkey sounds> Hi, Rob here :-)
0
 
DeltavcommAuthor Commented:
Thanks for the info, that did the trick.  After I changed the retain deleted mailboxes and retain deleted messages to 0 the next online defrag reported over 4 GB would be freed and in fact we saved about 5 GB after we did the off-line defrag this weekend.
0
 
redseatechnologiesCommented:
Excellent, glad to hear that did it for you,

-red
0

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now