Solved

Database size Best Practices

Posted on 2007-11-16
4
811 Views
Last Modified: 2008-05-24
We are running Exchange 2003 Standard.  I arrived here about three months ago to find that the company had never bothered to write any policies relative to email retention; consequently, the size of the Database is enormous (50GB).  The limit was set in the registry to 52GB.  I have since altered the registry to reflect 75GB; however, I have spoken with a couple of Exchange administrators who have told me that it is risky to house the information store in a single DB file of this size.  The recommendation has been made to upgrade to Enterprise Edition and migrate the information store to the new environment and split the DB files into multiple Mailbox Stores (Standard Edition does not support multiple stores).  I am experiencing some resistance from the decision makers (who frankly have not made the best decisions in the past) about doing an upgrade.  They would prefer that we stay in the Standard edition environment and encourage users to delete and archive.  This may very well help in the short term but, we have a terrible storage environment and I don't feel that we can support a decent archiving policy until we get our hands around the storage issue.  I am concerned that we are running a risk with keeping such a large DB (even with archiving ...Exchange still just creates "White Space" and does not actually decrease the physical size of the DB files.) I have been told running such large files can lead to corruption.

Does anyone have any advice about an appropriate tact to take.

Upgrade?  Stay put? No brainer?

Thank you
Paul

0
Comment
Question by:saxophobe60
[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
4 Comments
 
LVL 22

Accepted Solution

by:
ATIG earned 63 total points
ID: 20301329
50 GB edb is nothing....... MS does recommend that you attempt to keep it under 100gb but this mainly has to do with recovery.....

yes if you can get EE edtion and create more SG's then you have access to more store cache since the cache is at the SG level.

of course the smaller the db is the faster you backups and restores can be, you need to define what your SLA is which can dictate you design.

0
 
LVL 104

Assisted Solution

by:Sembee
Sembee earned 62 total points
ID: 20301455
As you are running standard edition you have no options when it comes to splitting the data up. As already mentioned, 50gb is considered nothing. You can go up to 75gb which around the point i would suggest second databases anyway. If I am doing a large deployment then around 50gb per mailbox is where I want to be - for the same reason as above - backup and restore.

If you want to upgrade to Enterprise edition you would have to buy Exchange 2007 Enterprise edition and use downgrade rights. If you are going to buy Exchange 2007 then you might want to look at how much a new 64 bit server is with a copy of Exchange 2007 standard. All versions of Exchange 2007 have (theoretical) unlimited database store size.

Simon.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Large Outlook files lead to various unwanted errors and corruption issues. Furthermore, large outlook files can also make Outlook take longer to start-up, search, navigate, and shut-down. So, In this article, i will discuss a method to make your Out…
Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
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…
how to add IIS SMTP to handle application/Scanner relays into office 365.

688 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