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.


About Pratik Vyas

Hi Readers, Welcome to Pratik’s SharePoint Blog. First of all Thank you very much for taking interest and spending time to tour my Blog I am in the ocean of SharePoint since January 2008 (almost 4 years), and still I feel I have to go more deep. I am working with a well known MNC as a SharePoint Consultant. Here I used consultant because I do a little development and customization with administration. I am very much interested in Microsoft products. I have started blogging since 2008 but I can say in real manner I have started it in 2011 (as I have posted only 4-5 blogs from 2008 to 2011 J) I believe there isn’t anything impossible in SharePoint, the only thing is sometimes we have to think something off track. I have posted couple of blogs which was discovered by going some off track, we can simply say it TRICKS. Feel free to reach me in case of any issues or queries I will be more than happy to help you. Good bye and Happy Reading, Cheers !!
This entry was posted in How to Create a Site Collection in a Specific Content Database, SharePoint Administration. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s