Solved

Exchange Server mailbox database growing nearly 200 GB ?

Posted on 2013-10-29
9
439 Views
Last Modified: 2013-11-13
Hi people,

Is there any possible way to decrease the size of the Exchange Server mailbox DB which grows larger than 200 GB ?

What are my options ?

Since I'm using CCR, I was reading somewhere on the Technet that 200 GB is the maximum limit of the database.
0
Comment
[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
9 Comments
 
LVL 15

Expert Comment

by:Skyler Kincaid
ID: 39608728
Is the database that size or is it the logs? What version of Exchange are you using?
0
 
LVL 22

Assisted Solution

by:Nick Rhode
Nick Rhode earned 84 total points
ID: 39608769
Check to see if the logs need to be cleared by doing a backup of exchange or a full backup.

If this is the actual database that grew you might want to sort through your mailboxes or consider archiving to free up space.  This will not decrease the size of your mail database but will create whitespace which exchange will fill up the whitespace before continuing to grow.  

If you wanted to technically "shrink" the database you have 2 options:  

Create a new database and move the mailboxes to it or offline defrag
http://exchangeserverpro.com/defrag-exchange-2010-mailbox-database/
0
 
LVL 5

Assisted Solution

by:noufs
noufs earned 83 total points
ID: 39608785
Hello,

The only way to decrease your Exchange 2007 database is the defragmentation. You will need to archive mailbox before that.

Here is the link : http://technet.microsoft.com/en-us/library/aa998863(v=exchg.80).aspx
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Assisted Solution

by:leason22
leason22 earned 83 total points
ID: 39609132
Our Exchange server is Exchange2003. It has an embedded limit of 70 gigs. With an enterprise of 400 users. We have to schedule downtime roughly twice a year to take it offline, then run a defrag on the database. This compresses it back down.
Also, it's best practice to implement a mailbox size limit on every mailbox. Users, executives, designers, etc.
0
 
LVL 63

Assisted Solution

by:Simon Butler (Sembee)
Simon Butler (Sembee) earned 83 total points
ID: 39609387
Everything has failed to notice this: "Since I'm using CCR"

Offline defrag isn't an option for you because you are in a cluster.

The only option available to you is to create a new database, move the users to the new database, then remove the original in the correct way for a CCR cluster. Nothing else will maintain the cluster.

It should be noted that an offline defrag is NOT risk free and is not something that is recommended by Microsoft to be done as a regular task.

Simon.
0
 
LVL 8

Author Comment

by:Senior IT System Engineer
ID: 39610220
Thanks all for the reply. In this case I'm using exchange server 2007.

The disk space is 73% used and I just realized that the log and the DB is on these drive (RAID-10) with circular logging turned on.
0
 
LVL 15

Assisted Solution

by:Skyler Kincaid
Skyler Kincaid earned 167 total points
ID: 39610621
You may need to move the database and add space to the drive. If your database is growing you can also look at see what mailboxes are using a ton of space and start implementing some rules so it doesn't happen again.
0
 
LVL 8

Author Comment

by:Senior IT System Engineer
ID: 39610625
What are the best way to monitor which of the mailbox growing in one database ?
0
 
LVL 15

Accepted Solution

by:
Skyler Kincaid earned 167 total points
ID: 39610657
Here ya go:

Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | ft DisplayName,@{label="TotalItemSize(MB)";expression={$_.TotalItemSize.Value.ToMB()}},ItemCount

http://social.technet.microsoft.com/Forums/exchange/en-US/1d95e6b4-e3cf-4bce-85af-8ce0d94d9cef/veiwing-mailbox-sizes-in-exchange-2007?forum=exchangesvradminlegacy
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

There are times when we need to generate a report on the inbox rules, where users have set up forwarding externally in their mailbox. In this article, I will be sharing a script I wrote to generate the report in CSV format.
This article outlines some of the reasons why an email message gets flagged as spam on a recipient's end.
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…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Suggested Courses

632 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