Solved

Database size conisderably larger than total mailbox size after offline defrag

Posted on 2006-10-24
7
576 Views
Last Modified: 2012-05-05
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
Comment
Question by:Deltavcomm
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 39

Accepted Solution

by:
redseatechnologies earned 500 total points
ID: 17800715
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
 
LVL 27

Expert Comment

by:Exchange_Admin
ID: 17800717
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
 
LVL 27

Expert Comment

by:Exchange_Admin
ID: 17800719
Red,
You beat me to the punch. That is what I get for being longwinded.
lol
0
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.

 
LVL 39

Expert Comment

by:redseatechnologies
ID: 17800860
At least we both managed to beat the google monkeys :)

That is all that counts!
0
 
LVL 9

Expert Comment

by:robjeeves
ID: 17801147
<Monkey sounds> Hi, Rob here :-)
0
 

Author Comment

by:Deltavcomm
ID: 17838513
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
 
LVL 39

Expert Comment

by:redseatechnologies
ID: 17838541
Excellent, glad to hear that did it for you,

-red
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Lotus Notes – formerly IBM Notes – is an email client application, while IBM Domino (earlier Lotus Domino) is an email server. The client possesses a set of features that are even more advanced as compared to that of Outlook. Likewise, IBM Domino is…
Find out what you should include to make the best professional email signature for your organization.
In this video we show how to create a Shared Mailbox 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 >> Sha…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

729 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