Multiple databases for 1 Web Application

Sometimes I get the impression that a lot of people think you can only have 1 database for every Web Application. Well a lot of people (actually all of them that think that way) couldn't be more wrong than that. In the category people who do know this fact, most of them don't know how to control where to put Site Collections. Well, this post is all about that.

In your database you can place multiple Site Collections. So for your database a Site Collection is seen as "one item" (hence the Site Collection List in "Central Administration > Application Management"). This means you can make multiple databases, with one Site Collection in every database.
Why is this so interesting, well for example:

  • Performance
  • Backup / Recovery
  • Copying data to another farm (let's say to the staging environment)

How do you do it?

Well, when a Site Collection is created, MOSS Searches for the first available database.
When is a database available? A database is available when it's status is "Online".
You can change this status when going to "Central Administration > Application Management > Content Databases" and then clicking on the database of your choice.

AND HERE is the misunderstanding: When you set the status to "Offline" it does NOT mean the database is unavailable. It ONLY means than you cannot create new Site Collections (aka Top Level Sites).

So if you want to create a new database for 1 specific Site Collection, do this:

  1. Create a new content database
  2. Set the other databases all to status "Offline"
  3. Create your Site Collection (It will be put automatically in your fresh made database)
  4. Set that database to status "Offline" (This prevents other Site Collections to be made in this database)

Don't forget after doing this, that you at least have to set one database back online. Otherwise it won't be possible for new users to create their MySite. Since every Mysite is a Site Collection.

Today I installed a MOSS 2007 Farm for a customer and at the end we had 4 content databases. Three of them have now the status "Offline" and each has 1 Site Collection. The forth is reserved for the MySites and thus has status "Online"

Keep on spinning
Tom

One last personal thingy to finish this post: Next week Saturday I'm moving out of the parents house to go live in a roofapartment in the fantastic city of Ghent. So anyone who's strong is always welcome to help moving furniture and stuff Wink

 

 

 

Published donderdag 21 juni 2007 21:30 by Tom Vandaele

Comments

# re: Multiple databases for 1 Web Application

donderdag 21 juni 2007 13:36 by Bart Bultinck

nice post Tom ! and by the way congrats on the decision ! You don't want me having around to help moving as it will probably cost you by bringing all your stuff to some repairshop... catch ya laterz

//Bart

# A Sharepoint Legend : One Web Application = One Content Database

dinsdag 18 december 2007 17:03 by Blog de Jérémie Clabaut (ak MinSou)

Today I heard from a "Sharepoint Expert" that we can create only one content database per web application on Sharepoint. From an expert, It makes me laugh Tom Vandaele explains (better than me ) on his blog why this assertion is false ! &#1

# Understanding IIS Web Site and SharePoint Web Application « Nishant Rana’s Weblog

Pingback from  Understanding IIS Web Site and SharePoint Web Application « Nishant Rana’s Weblog

# Fx35 Dual Exhaust, Used Infiniti Fx35 Colors

vrijdag 21 mei 2010 8:21 by Fx35 Dual Exhaust, Used Infiniti Fx35 Colors

Pingback from  Fx35 Dual Exhaust, Used Infiniti Fx35 Colors

# Used Dodge Rd200 Pickup Salvage Yards, Rd2000 Fog Light Great

Pingback from  Used Dodge Rd200 Pickup Salvage Yards, Rd2000 Fog Light Great

# Change Bulb Volkswagen New Beetle, 1.8 T Discount Vw Beetle

Pingback from  Change Bulb Volkswagen New Beetle, 1.8 T Discount Vw Beetle

# Parts Sale Mercedes Benz 280sl, How To Recovery Mercedes Benz 280sl - 4.akemet.com

Pingback from  Parts Sale Mercedes Benz 280sl, How To Recovery Mercedes Benz 280sl - 4.akemet.com

# Lsc27921sw Cu Ft, Sc2 Installation Forums - 5.cmanager.org

Pingback from  Lsc27921sw Cu Ft, Sc2 Installation Forums - 5.cmanager.org

# Fiero Ls1 Conversion, 6000 Parts Headlight Assembly Pontiac Fiero - 214.akemet.com

Pingback from  Fiero Ls1 Conversion, 6000 Parts Headlight Assembly Pontiac Fiero - 214.akemet.com

# Pontiac Lemans Bulb Turn Signal Switch Electrical, Lemans Girl - 321.tijuanareader.com

Pingback from  Pontiac Lemans Bulb Turn Signal Switch Electrical, Lemans Girl - 321.tijuanareader.com

# Relay 1 Shop, Relay 3 Party Following - 126.cmanager.org

Pingback from  Relay 1 Shop, Relay 3 Party Following - 126.cmanager.org

# Cl600 Gamefaqs, Cl600 Overstock - 3.tijuanareader.com

Pingback from  Cl600 Gamefaqs, Cl600 Overstock - 3.tijuanareader.com

Powered by Community Server (Commercial Edition), by Telligent Systems