Generally, site collections are created using the Central Administration. However, these means don’t give us the option to select a specific Content Database where we wish the site collection to reside.
Well, PowerShell comes to the rescue again. Below is the PowerShell script that can be used to create the site collection in the specific content database we intend. Change the input parameters and run the snippet as per your need.
The Code
- $myURL = "https://mysharepoint.com/sites/mysitecollection"
- $myContentDB = "myContentDatabaseName"
- $mySCName = "mydesiredSiteCollectionName"
- $mySCDesc = "mydesiredSiteCollectionDescription"
- $PrimaryLogin = "DOMAIN/User"
- $mySCTemplate = Get - SPWebTemplate "STS#0"
- New - SPSite - Url $myURL– ContentDatabase $myContentDB - Name $mySCName– Description $mySCDesc - Template $mySCTemplate - OwnerAlias $PrimaryLogin
Description of the Parameters
| Command | Usage |
| New-SPSite | The command for creating a new site collection at the specified URL |
| -URL | The desired URL of the site collection that is to be created |
| -Content Database | This logs in the specified content database name where the new site collection will be created |
| -Name | The name of the site collection that is to be created |
| -Description | The description of the site collection that is to be created |
| -Template | This represents the web template type of the site collection (eg: Blank Site- STS#1, Team Site - STS#0, etc). Click here for the entire code of templates |
| -OwnerAlias | This is the primary site collection administrator |