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.