• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • Last Modified:

DB won't go down even after defrag

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
reysrivera
Asked:
reysrivera
  • 3
  • 2
3 Solutions
 
michaelgoldsmithCommented:
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
 
reysriveraAuthor Commented:
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
 
michaelgoldsmithCommented:
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
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
reysriveraAuthor Commented:
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
 
michaelgoldsmithCommented:
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
 
drothbartCommented:
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

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

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