Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Large Database warning on Exch 2003

Posted on 2010-11-10
10
Medium Priority
?
771 Views
Last Modified: 2012-05-10
Hi guys, hope you can help me!

We have an exchange 2003 server with server 2003 OS, and i ran the Microsoft Exchange Server Best Practices Analyzer Tool, and received the following message:
Large database warning: The mailbox store "User_Storage_2 on server NJLAWMAIL04 is 104GB in size. It is recommended that the maximun database size does not exceed 100GB

should this of a concern? and how do i fix this?

Thanks
0
Comment
Question by:J Molina
  • 2
  • 2
  • 2
  • +4
10 Comments
 
LVL 20

Expert Comment

by:Rick Fee
ID: 34102707
There is a registry key to edit to allow the increased size of the DB.   I take it you have Exchange 2003 Enterprise?

http://www.petri.co.il/change_store_size_limits_ex2003_sp2.htm

0
 
LVL 6

Expert Comment

by:Nagarajb
ID: 34102715
It is suggested to maintain or limit the Database size to 100GB, b'cas it is much easier to recover the database during recovery purpose and also it takes lesser time to complete online maintainence.
0
 
LVL 15

Expert Comment

by:JBond2010
ID: 34102760
The space is logical - so a physical store of 100gb is not a problem if you have more than 5gb of white space in the store. The size of the store would have no impact on the users in Outlook, unless your storage was badly configured. I have built and maintained servers with stores over 250gb in size and they were fine - because the storage was configured correctly.
However you are correct on the behaviour of the database if you removed all of the content. The simple rule is that the Exchange database never shrinks in its physical size.

I am in the middle of a blog posting on this subject, so I have some text to hand.

The EDB file should be thought of as the MAPI database and will consist mainly of internal email.
The STM file should be thought of as the SMTP database and will consist mainly of external email.

What tends to happen when there is a data base purge is that internal email is deleted, but more external email arrives, so there is a mismatch.
Do you receive lots of attachments from external senders?

As for the IFS files, do not delete them.
http://support.microsoft.com/kb/260532

0
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.

 
LVL 15

Expert Comment

by:JBond2010
ID: 34102766
Because there are whitespaces in the edb file, these happen when stuff is deleted.

Deleting items does not reduce the size of your database

Only way to do that is by doing an offline defrag of the database however you would need the space to have 2 database which it appears you do not

0
 
LVL 4

Expert Comment

by:Harkins
ID: 34102768
Hi jbm,
You can have up to 4 storage groups with 4 databases in each storage group. It is recommended you split your mailbox store into smallers ones. By doing this your database sizes will be smaller, which in turn will speed up backup/recovery of a database, and also, should one database go down, you will not lose your whole Exchange system.
To create the mailbox stores, right click on your Storage Group, and select New... Mailbox Store. Once you have created it, you can then click on a mailbox in ESM and move it to the new mailbox store.
Once you have moved half the mailboxes, you will need to run a offline defrag (eseutil) on you current mailbox store to reclaim the disk space.
HTH,
Harkins
0
 
LVL 3

Expert Comment

by:danora
ID: 34102842
perfectly said Harkins
0
 

Author Comment

by:J Molina
ID: 34103231
thank you guys, your notes was very informative, but i need steps...
0
 
LVL 5

Accepted Solution

by:
sabk earned 1000 total points
ID: 34103338
0
 
LVL 4

Expert Comment

by:Harkins
ID: 34107600
Do you have a single mailbox store?
0
 

Author Comment

by:J Molina
ID: 34113176
no, i see there 2 mailbox stores
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Are you an Exchange administrator employed with an organization? And, have you encountered a corrupt Exchange database due to which you are not able to open its EDB file. This article will explain all the steps to repair corrupt Exchange database.
Are you looking for the options available for exporting EDB files to PST? You may be confused as they are different in different Exchange versions. Here, I will discuss some options available.
To show how to generate a certificate request 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 Servers >> Certificates…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

877 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