?
Solved

Database size Best Practices

Posted on 2007-11-16
4
Medium Priority
?
815 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 252 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 248 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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
A list of top three free exchange EDB viewers that helps the user to extract a mailbox from an unmounted .edb file and get a clear preview of all emails & other items with just a single click on mailboxes.
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…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…
Suggested Courses
Course of the Month14 days, 7 hours left to enroll

771 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