.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Sandeep Singh

Home >> Articles >> SharePoint >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Create Site Collection with new Content Database in SharePoint

Posted By:Jean Paul       Posted Date: March 30, 2014    Points: 200    Category: SharePoint    URL: http://www.dotnetspark.com  

In this article we will explore a Central Administration route to create new site collection with specified content database in SharePoint 2010

In this article I would like to explore the trick that allows Creating Site Collection with New Content Database, everything through Central Administration.


Why a trick?

A trick is needed as the new site collection creation does not allow us to select the content database name. It randomly selects the database & this aspect we need to control.

What are the steps involved?

Following are the steps:

6. Create new content database

7. Make all other databases to offline

8. Create new site collection

9. Ensure new database name

10. Turn back all databases to online

Step 1: Create new content database

Open Central Administration & choose the option Manage content databases.


In the appearing page create a new content database.



Step 2: Make all other databases to offline

Back in the databases list, select all other databases (except NewDb) & make them as Offline.


Then save changes, continue this for all databases except our NewDb. The final list should look like:

Please note that only one database is active now, this will make SharePoint to choose it while creating new site collection.


Step 3: Create new site collection

Now our new content database is created & set to the Started state, we can proceed with creating new site collection. Chose Central Administration > Create site collections link.


Enter the site collection creation parameters and click ok button. Please note that there is no field to specify the content database, it will be automatically taken from the available content database in the background.


Step 4: Ensure new database name

Once the new site collection is created, you can verify the database name. Open Central Administration > Application Management > View all site collections link.

In the appearing site collection list, click on the new site collection, you can see the database name in the right hand side panel.

Please note that the database name is NewDb.

Step 5: Turn back all databases to online

Now we have completed the new site collection creation with new content database name. Please turn back all the content databases to Ready state.

Open Central Administration > Manage content database > choose each > set to Ready state.


After completing the step, you will see all the databases set to online.



Please note that PowerShell command New-SPSite provides the option to specify a content database name.




In this article we have explored a Central Administration route to create new site collection with specified content database.

 Subscribe to Articles


Further Readings:


No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend