Creating site collections on specific content database

Sometimes there are situations where we need to create site collections with a specific content database. You could achieve this using the below steps.

1.  Create / User existing web application in which you want to create site collections.
2. Go to Central Admin > click Application Management > click Manage Content Databases

 Select your desired web application (the one in which you want to add site collections).

You can see below screen now,

Note: You will be able to see a database name that is the database with which your web application is associated. In case you create a new Site collection in this web application then by default the visible database will be used.

   3. Click Add new Content Database, below screen appears 

      

 4.       Add new database name and click OK, in my case I am creating 2 such databases  KP1 and KP2.

5.       Once you are done you can see the created databases as below.

That’s it you now have two databases in order to create site collection to specific database. At present all the 3 databases are having Status to start. There are two ways to create site collection to a specific database will see both.

First Way: Set all unwanted Databases offline.

Let’s first create Site Collection in KP1 database.

1.  First of all click on database kp2 and set its status to offline. Below figure will guide you.

Perform same operation for all databases except KP1. This will result into below screen.

2.   Now when all the other databases except KP1 are stopped, when you create a site collection it will be associated with KP1.

Second Way: Set Site Collection max capacity.

Now let’s create a new site collection in KP2 database. It is recommended that always set Total number of site collections less than the maximum number of site collections.

1.    Set Maximum capacity of site collection of the database to 1 for all other databases except for KP2. 

 

Below Screen will be resulted,

  2.    Now when you create new site collection it will be using KP2 database as capacity of other database is less.

Other than above two ways, of course you can use Power Shell command. Hope this helped you.

  

Regards, 

Keyur Pandya