Creating a Site Collection in a New Content Database (Records Center)
1. Go to the Managed Content Databases Section under Application Management
2. Take All the databases present in this section to –“Offline”
o Click on the database name (all need to be stopped)
o Change the database status to Offline
o Click OK
Note that simply taking the databases offline does not affect user functionality; it only disallows new Sites from being created in the specific Content Database.
3. Add new content database in Central Administration > Application Management > Content Databases. (you can use different SQL server). Now all new sites will be created in this content database.
4. Choose the web-application and add a name for the content database:
5. Choose the Search Server and keep the rest as default:
6. Make sure the content database is started.
7. Create new site collection from Add new content database in Central Administration > Application Management>Create Site Collection
8. Choose the web application; Add the Title, Description and URL for the Record Center Site. Choose Record Center template from the Enterprise tab
9. Choose the Primary and Secondary Site collection administrators
10. If you see the File not found Error:
Do the following steps:
· First you need to get to your Site Actions Site Settings by adding /_layouts/settings.aspx to your URL.
· Click on Site Collection Features and Activate all the features
· Click on Portal Connection under Site Settings and Add Main portal address.
· Click on Master Page and even if it already says Default.aspx is selected, re-select the default master page again and click OK. This will resolve the error
11. Go back to the central administration- Application management and click on content database. The Current number of Sites under the new content database should be one now
12. Click on the old content database and change the status to Ready. This will enable any new site collections created to be created on any of the Site collections.
13. To restrict the Report Center content database to just have the Report Center Site collection change the status to Offline. This will disable Record center content database to accept any new site collections created on it.
Content database- Site Collection description:
When there are multiple content databases in ready state, every new site collection created will be added to the content databases in a round robin fashion. For example,when we have two content database databases in ready status and would like to create 4 site collections. First site collection will be created under first content database and then the second site collection under the second content database. The third site collection will be created under first content database and fourth one again under the second content database. The same cycle continues for any new site collections.
To force a site collection to be created under a particular content database, all other content databases status should be changed to offline and the particular content database should be set to ready.
Content database- Site collections- Sites
If there are two site content databases and each with a site collection associated with it, any new sub site created under a site collection will use the content database the site collection is associated with, whether the content database has a status of Ready or Offline. For e.g.
Let’s consider two content database- wss_content1, wss_content2 and two site collections Site collection1 and Site collection2 respectively under each content database. Create few Sub sites under Site collection1 and Site collection2. Change the status of wss_content2 to offline. When a new sub site is created under the Site Collection2, it will still use wss_content2. This despite the fact that wss_content2 was set to “offline”.
11.11ettings.aspx to your URL
