Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Algorithm for choosing content database for a STSADM restore

  Asked By: Beth    Date: Jun 21    Category: Sharepoint    Views: 2880

Does anyone know the algorithm that WSS uses to decide what content
database to restore a site collection to when using STSADM or where
this is documented/discussed?

We are trying to split out site collections into smaller databases
than our current 150 gb content database. We want to get down to 6-7
content databases of 20-25 gb in size.

I know taking content databases offline does not affect STSADM
restores from experience but I would like to know how we can get the
collections in the right content databases.



2 Answers Found

Answer #1    Answered By: Kyla Eckert     Answered On: Jun 21

You can creating the new content  databases you wish to restore  to. Then change the settings in Administration to set the max sites for that Content DB to the current  number of sites. (f you have 100 in there set the max to 100). When this is done, if you then do a restore it should restore it into the new content DB. The only other option could be to use SMIGRATE instead, but there are limitations with it.

Answer #2    Answered By: Alisha Holmes     Answered On: Jun 21

SharePoint 2007 gives us the ability to take a content  database 'offline', showing as stopped. site  Collections in this database  continue to function and accept uploads according to Site collection  quotas. But after taking it offline, you now cannot create further site collections  in this content database, you must create a new content database for new site collections.

1. Stop all associated content databases with the web application where you want to create a site collection

2. Create a new associated content database

3. Create a Site Collection in this web app

You have now created the new site collection in the above created content database