Thursday, January 24, 2013

How to Create a Site Collection in a Specific Content Database

You can follow the below steps if you have a requirement of creating a Site Collection in to a Specific Database when you have multiple Content Db for a Particular web application .
  1. Under the Application Management section access the “Content Databases” link.
  2. In the upper right hand corner make sure you are in the correct Web Application. If you aren’t then change to the correct one.
  3. Click the link for each Content Database you have listed under the “Database Name” heading.
  4. When the “Manage Content Database Settings” page opens set the “Database Status” to “Offline” and then click “OK”. After you click ok you’ll be taken back to the “Manage Content Databases page where the database you just changed should now show as “Stopped”.
  5. Click the “Add a Content Database” link and create a new content database. Do not make any changes to the “Database Status” setting. It will show as “Started” in the list of Content Databases. You will also notice that the “Current Number of Sites” will be equal to 0.
  6. Navigate to the SharePoint Site Management section and create your new site collection.
  7. Go back to the Manage Content Databases list and you will now see that the Content Database you just created now shows that the Current Number of Sites is equal to 1.
You have just created a new site collection in the content database of your choice.

No comments:

Popular Posts


The opinions expressed on this blog are the personal views of Pratik's SharePoint Blog, and do not represent or reflect the viewpoints or policies of any past, present, or future employer, colleague, or customer, or any other entity. The posts on this blog are provided ‘as is’ with no warranties, express or implied, and confer no rights. Use of information contained within this blog, including specific technical steps mentioned herein, is at your own risk. References to specific software products, processes, resources, or companies do not imply any endorsement.