July 01, 2009 05:01 PM

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

Rating: (0)
Windows IT Pro
InstantDoc ID #102381

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.

ARTICLE TOOLS

Add a Comment

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 7/1/2009 2:14:17 AM


You must log on before posting a comment.

Are you a new visitor? Register Here

advertisement

Related Resources

Keep Your Email Flowing
A Podcasts by AppAssure Software
The Essential Guide to Blade Servers
A Essential Guides by Hewlett-Packard
More

advertisement

GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

eBooks

Playbook for a Virtualized Datacenter | During challenging times, optimizing the IT infrastructure becomes imperative. Many organizations are looking to extend their virtualization efforts to encompass the entire datacenter. Get a step-through of your technology options and more.

White Papers

As the advances in USB devices have made them invaluable to most business users’, they have also exposed organizations to enormous risks. Learn how to easily enforce device/port control and data encryption policies without requiring new infrastructure and additional admin overhead.

WEB SEMINARS

Is Flexible Lockdown Possible? Join Darren Mar-Elia for this free web webinar exploring the various methods you should consider to protect and control your desktops while also understanding the impact on the end user community.
View Seminar On-Demand.

eLearning Series

Windows IT Pro brings the experts direct to you to share their real-world perspective, experience, and expertise. During each event, three sessions stream in real time, allowing you to learn, to ask questions, and to get solutions.
Upcoming event: SQL Server Consolidation

Subscribe to Windows IT Pro!

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.