Sharepoint 2010 Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint 2010       RSS Feeds

Preparing for new environment - new content databases

  Asked By: Celia    Date: Mar 10    Category: Sharepoint 2010    Views: 1290

I am getting ready for SharePoint 2010 migration. Currently we have two
fairly large content databases. When we move to SP 2010, I want to have
all new content go to new content databases.

What is the best way to prevent new content from going to the two
existing databases and create two new content databases that new content
can go to via a round robin fashion.

Also, where can I find information on create a special content databases
for one site collection and then locking that content databases so that
it only contains one site.



5 Answers Found

Answer #1    Answered By: Shelley Reese     Answered On: Mar 10

Set the pre-existing content  databases to off-line. Users will still be able
to access the site and upload documentation but new sites will not be able to be
created. Also, if you drill into the content database itself, there's an
option to set the maximum number of sites that it can contain.

Answer #2    Answered By: Omar Arnold     Answered On: Mar 10

This sounds exactly like what I am trying to accomplish. Do you know of any
additional resources that I can learn more about this…I would like to set this
up for several of our content  databases.

Answer #3    Answered By: Christen Roberson     Answered On: Mar 10

I advise against setting the databases  offline, there are some unintended
consequences by doing so, such as disable the profile synch. Setting the max
sites a content  database can contain is the right way to do.

Also SharePoint 2010 has lots of improvements with regard to this, see

Answer #4    Answered By: Faith Delgado     Answered On: Mar 10

For clarification… setting a database to offline will prevent new Site
Collections from being added to the database, not sites. If users have
permission to create subsites, they will still be able to do this in an
off-line database. Max sites a database can hold also applies to Site
Collections, not sites.

Answer #5    Answered By: Amrita Durgude     Answered On: Mar 10

There's no great way to do this. Setting the database offline has the drawbacks
you mentioned, it breaks profile sync, among other things. Setting the Max value
is a good way, but it takes a lot of work. That method breaks as soon as you
delete any site collections. So every time you create a site collection you have
to make sure every database's max and current are the same. Kind of a pain.

Didn't find what you were looking for? Find more on Preparing for new environment - new content databases Or get search suggestion and latest updates.