Solved

DB won't go down even after defrag

Posted on 2008-10-14
6
192 Views
Last Modified: 2010-04-07
To all,

I have an exchange 2003 database that we keep trying to defrag, it goes through with no errors, but the size won't go down the db is showing 26gb but if you add up the mailboxes its only 11gb now after cleaning some up, any ideas?

Thanks!!
0
Comment
Question by:reysrivera
  • 3
  • 2
6 Comments
 
LVL 12

Expert Comment

by:michaelgoldsmith
Comment Utility
Unless you dismount the mailbox store and run an "offline defrag", than Exchange just marks the database that has been cleaned up as "white space". That is why the database remains the same size.
0
 

Author Comment

by:reysrivera
Comment Utility
The last time I check it won't let you defrag unless the DB is dismounted so answer your question the DB is dismounted but nothing gain on the DB size.
0
 
LVL 12

Accepted Solution

by:
michaelgoldsmith earned 450 total points
Comment Utility
Sorry, thought you were referring to the cleanup mailbox wizard.

What do you have your retention settings set at?

Try setting your retention to 0, clean up everything, and run another offline defrag. That should show a reduction in DB size.

 
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

Author Comment

by:reysrivera
Comment Utility
I have the retention set to 7 days so I set it to 0, run the defrag again and no reductionon DB. Should I wait so auto maintenance wil do it thing and run defrag?
0
 
LVL 12

Assisted Solution

by:michaelgoldsmith
michaelgoldsmith earned 450 total points
Comment Utility
yes. you need to have auto maintenance run (i assume overnight as that is the default). Then run an offline defrag at the next possible window.
0
 
LVL 5

Assisted Solution

by:drothbart
drothbart earned 50 total points
Comment Utility
If online defrag runs correctly, it reports the amount of white space after running. I believe the event id is 1221, but I could be mistaken.

Like Michaelgoldsmith says, deleted items (dumpster items) will take up space too. I believe you can add those columns to the ESM view. I know you could in 5.5. That will show you how much the dumpster items are consuming.

I'm away from my servers or I'd check for sure; sorry.

Dan
0

Featured Post

Shouldn't all users have the same email signature?

You wouldn't let your users design their own business cards, would you? So, why do you let them design their own email signatures? Think of the damage they could be doing to your brand reputation! Choose the easy way to manage set up and add email signatures for all users.

Join & Write a Comment

Suggested Solutions

"Migrate" an SMTP relay receive connector to a new server using info from an old server.
This article explains in simple steps how to renew expiring Exchange Server Internal Transport Certificate.
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
how to add IIS SMTP to handle application/Scanner relays into office 365.

771 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

10 Experts available now in Live!

Get 1:1 Help Now