Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Exchange Server mailbox database growing nearly 200 GB ?

Posted on 2013-10-29
9
Medium Priority
?
440 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 336 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 332 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
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

 
LVL 1

Assisted Solution

by:leason22
leason22 earned 332 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 332 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 668 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 668 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

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

New style of hardware planning for Microsoft Exchange server.
How to deal with a specific error when using the Enable-RemoteMailbox cmdlet to create a mailbox in the cloud-based service, for an existing user in an on-premises Active Directory.
The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

670 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