Solved

Exchange edb file growing very large

Posted on 2010-09-06
16
1,285 Views
Last Modified: 2012-05-10
Our Exchange (2003) database files have grow to a large size where they are close to outgrowing the drives that they are on. I need to reduce their size.

edb file is 100 GB
stm file is 35 GB

Current combined size of users mailbox's is approx 30GB

 Further investigation has shown that the Maintenance interval is not enabled (or specifically set to Custom Schedule and no times selected).

If I just enable the Maintenance shedule, will this reduce the size of the database significantly or will i need to do an offline defrag using Eseutil?
Not sure why this was disabled in the first place but our exchange store had to be rebuilt a year or so ago, so perhaps it was never turned on again after that.

Either way my first step is going to be to backup the databases to an external drive.

Is there anything else I should be looking at or steps I should take?
0
Comment
Question by:danmax1979
  • 8
  • 5
  • 3
16 Comments
 
LVL 74

Accepted Solution

by:
Glen Knight earned 250 total points
ID: 33615376
Exchange does not automatically reduce the size of the database.

The only way to reduce the database size is by running an offline defrag. The maintenance however will create whitespace. Check out my guide here: http://www.experts-exchange.com/Software/Server_Software/Email_Servers/Exchange/A_2730-Exchange-Offline-Defrag.html
0
 
LVL 1

Author Comment

by:danmax1979
ID: 33615473
Thanks, i'll check it out, i'll run the backup tonight and hopefully do the defrag tomorrow night.
0
 
LVL 4

Expert Comment

by:paritoshjani
ID: 33615594
danmax1979,

Please ensure that you have sufficient downtime as online defrag for 100 GB is going to take a lot of time. Is 100 GB utilized by a single database or multiple databases ?
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 4

Assisted Solution

by:paritoshjani
paritoshjani earned 250 total points
ID: 33615650
danmax1979,

If you can map an alternate hard drive, I would recommend to start splitting the databases  to smaller ones. This will help you to manage each of them individually and also optimize the performance. (Hoping that you are not using SBS)
0
 
LVL 1

Author Comment

by:danmax1979
ID: 33615806
It is a single database, What is the process for splitting the database?
0
 
LVL 4

Expert Comment

by:paritoshjani
ID: 33615868
danmax1979,

You need to create a new database(s) on alternate drive (as your current HDD is full) and move mailboxes. Ideally database should be created to meet the organizational hierarchy. This will help you in future to manage the database.
0
 
LVL 74

Expert Comment

by:Glen Knight
ID: 33615900
Exchange 2003 Standard edition will only support a single mailbox database.
Unless you are using Enterprise this will not work.
0
 
LVL 1

Author Comment

by:danmax1979
ID: 33615912
Ok it is enterprise edition.
0
 
LVL 74

Expert Comment

by:Glen Knight
ID: 33615918
Then simply creating a new mailbox database and moving the mailboxes to this will provide you with a defragmeted mailbox store.
This is all detailed in my article I posted earlier.
0
 
LVL 1

Author Comment

by:danmax1979
ID: 33615930
Cool. I will let you know how I go.
0
 
LVL 1

Author Comment

by:danmax1979
ID: 33678047
Ok, so after plenty of heartache and some long days, I've finally got exchange back to some sort of stability.

Steps I took were as follows (repeating most of the above, but just for clarity):
1. Created new Mailbox store on a different drive
2. Gradually moved all Mailboxes over to that drive (this took me a couple of days)
(Good tip here is to go into the First Storage Group properties and change the location for the Transaction Logs, moving mailboxes generates lots of log files which can fill up the drive again if it is the same drive as your mailbox store)
3. Dismount original store, move off to an external drive (along with eseutil files) and perform the offline defrag on another workstation
4. Defrag ran overnight, took about 15 hours, but reduced the total file size from 130GB to 16GB.
5. Copy defrag'd files back to original location and mounted them back to the store.

My setup now is 3 different Mailbox Stores (one for each of our departments). I still have the original store but I would prefer to just delete it. When I try to delete it says "One or more Users currently use this mailbox store..." the only mailboxes remaining are SMTP and SystemMailbox, not sure how to move or disable those, any ideas??
0
 
LVL 74

Expert Comment

by:Glen Knight
ID: 33678073
Those mailboxes don't need to be removed since they are specific to the store.  You also cannot delete them.There must be another user that has attributes pointing to that store, probably a user that looks like it doesn't have any exchange settings or a deleted mailbox.  How long since moving the mailboxes did you try deleting the store?
0
 
LVL 1

Author Comment

by:danmax1979
ID: 33678112
The last mailboxes were moved from that store a couple of days ago.

I don't mind keeping it, although it is sitting at 14GB and there is nothing in it. Will regular maintenance reduce this? or should i do another offline defrag??
0
 
LVL 74

Expert Comment

by:Glen Knight
ID: 33678141
OK, using Active Directory Users and Computers under the View menu select add/remove Colima and add the exchange database column.

Then look for a) any users that are reporting they are still on that database or b) any users that don't have a database listed.

Are there any of either?
0
 
LVL 1

Author Comment

by:danmax1979
ID: 33678172
Yes there are 6 users still reporting to the original store.
0
 
LVL 1

Author Comment

by:danmax1979
ID: 33679035
Cool, I used Active Directory to move the remaining users to the new store and hey presto I was able to remove the old store.

Thanks guys for your help.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ESX 6.0 Best Practices for datastore size 5 74
exchange ,script 10 41
Exchange powershell help 2 28
powershell question need assistance 10 26
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…
This article explains in simple steps how to renew expiring Exchange Server Internal Transport Certificate.
In this video we show how to create a Resource Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: Navigate to the Recipients >> Resources tab.: "Recipients" is our default selection …
In this video we show how to create an Address List 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 Organization >> Ad…

813 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

17 Experts available now in Live!

Get 1:1 Help Now