How to create Site Collection in a specific Content Database

Add a new Content Database using Central Administration > Application Management > Content Databases > Add Content Database:

Type Database Name

NOTE! Make sure ”Maximum numbers of sites that can be created in this database” minus ”Current number of Sites” equals the largest number in which you want to add the new Site Collection:

View all site collection using Central Administration > Application Management > View all site collections  then you see root Web with WWS_Content database

And see /my (My Site) with WWS_Content database too

Go ahead and create a new Site Collection:

Title: My Home

URL: /sites/MyHome

Go back to the Content Database overview to see that the new Site Collection has been created in the new Content Database:

You can change “Number of sites before a warning event is generated” and “Maximum number of sites that can be created in this database” to make sure new Site Collections are added to the correct content database by click to WWS_Content_01 then edit

“Number of sites before a warning event is generated”: 1

Maximum number of sites that can be created in this database”: 2

“Number of sites before a warning event is generated” and “Maximum number of sites that can be created in this database” is changed

View all site collection using Central Administration > Application Management > View all site collections  then you will see new site collection with another content database

Read More

Creating site collection templates

In the article “How to create Site Collection in a specificContent Database” have a site collection was created is MyHome.

Go to Site > Site Actions > Click to Save site as template at Site Actions category

Type File name: MyHome, Template name: MyHome then click OK

Then save site as template successful, download that template and save to C:/ driver

Create site collection from template using Central Admin > Application Management > Create site collections

Title: My Home Template

URL: /sites/MyHomeTemplate

Select a template: <Select template later… > ! Important

Click to “Solution Gallery” link

Upload template “MyHome.wsp” in C:\ driver to solution then Active it

Go back before page you will see tab custom appear with template “MyHome” then click OK

At Visitors to this site: Use an existing group

Member of this site: Use an existing group

Owner of this site: Use an existing group

Then click OK

Result new site collection is created successful from template

Read More