Solved

Database size Best Practices

Posted on 2007-11-16
4
809 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
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

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…
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
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…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

839 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