Windows IT Pro is the leading independent community for IT professionals deploying Microsoft Windows server and client applications and technologies.
  
  
  Advanced Search 


July 01, 2009

Q. How many databases can I have in each storage group with Exchange Server 2007?

RSS
Subscribe to Windows IT Pro | See More Storage Articles Here | Reprints | Or get the Monthly Online Pass—only $5.95 a month!

A. In the standard edition of Exchange 2007, you can have up to five databases spread over five storage groups. With enterprise edition, you can have 50 databases spread over 50 storage groups. This works out to the ability to have one storage group for each database, which is actually the best practice, allowing you to remove shared transaction logs between databases and eases recoverability. There's no reason to put more than one database in a storage group, and you should add new storage groups as you add new databases.

There is a maximum of five databases per storage group, the same as in Exchange 2003, but as I mentioned above, it's strongly discouraged.

There are circumstances where you must have only one database per storage group. If you plan on using Cluster Continuous Replication (CCR), Standby Continuous Replication (SCR) or Local Continuous Replication (LCR), the only supported storage groups are those with one database in them. If you want to use CCR, SCR, or LCR and have multiple databases in each storage group, you'll need to redesign your databases so you only have one database in each storage group. This isn't a requirement for Single Copy Clusters (SCC), which don't actually perform any log shipping replication because there's only one copy of the database.

See this page for Microsoft's official database recommendations.

Related Reading:

Videos:

Audio:


Check out hundreds more useful Q&As like this in John Savill's FAQ for Windows. Also, watch instructional videos made by John at ITTV.net.

End of Article



Reader Comments
John, I understand from what you said that you've never restored Exchange databases, nor repaired Exchange databases.

I typically enable Circular Logging. This reduces the number of the log files. You may not enable it. But typically Exchange Server is backed up regularly and fully. A full backup erases the past log files, that is reduces the number of the log files.
In either case, the number of log files is low and replay of the log files does not take much time in a case of disaster.

So, there is no point not to add additional stores to a storage group.

muraty July 01, 2009 (Article Rating: )


You must be a registered user or online subscriber to comment on this article. Please log on before posting a comment. Are you a new visitor? Register now




Top Viewed ArticlesView all articles
Command Prompt Tricks

One reader shares his tip for setting up the command prompt to reflect a remote path. ...

WinInfo Short Takes: Week of November 9, 2009

An often irreverent look at some of the week's other news, including some more Windows 7 sales momentum, some Sophos stupidity, Microsoft's cloud computing self-loathing, more whining from the browser makers, Zoho's "Fake Office," and much, much more ...

Understanding File-Size Limits on NTFS and FAT

A general confusion about files sizes on FAT seems to stem from FAT32's file-size limit of 4GB and partition-size limit of 2TB. ...


Storage Whitepapers Turn to a Proven Server and Storage Migration Solution

The Impact of Disk Fragmentation on Servers

Take Control of Your Email: Understand the Business Reasons for Email Storage Management

Related Events Disk-to-Disk Grows Up

WinConnections and Microsoft® Exchange Connections

Check out our list of Free Email Newsletters!

Storage eBooks A Guide to Windows Certification and Public Keys

SQL Server Administration for Oracle DBAs

Keeping Your Business Safe from Attack: Encryption and Certificate Services

Related Storage Resources Introducing Left-Brain.com, the online IT bookstore
Looking for books, CDs, toolkits, eBooks? Prime your mind at Left-Brain.com

Discover Windows IT Pro eLearning Series!
Clear & detailed technical information and helpful how-to's, all in our trademark no-nonsense format


Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro DevProConnections IT Job Hound
Left-Brain.com Technology Resource Directory asp.netPRO ITTV Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 © 2009 Penton Media, Inc. Terms of Use | Privacy Statement