Create content database and add the site collection in that particular content db by powershell
In the central administration there is no option to select the database when you create a site collection but my best friend can help you. Check out this powershell commands.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
$ContentDatabase = "SP_Content_mysharepoint_myteamsite" $DBServer = "DBServerAlias" $WebApplicationURL = "http://mysharepoint.com" $SiteURL= "http://mysharepoint.com/sites/myteamsite" $WebsiteName = "My Teamsite" $WebsiteDesc = "An awesome collaboration site" $Template = "STS#1" $PrimaryAdminLogin = "domain\Admin" $PrimaryAdminEmail = "admin@sharepointloupe.com" $SecondaryAdminLogin = "domain\Admin2" $SecondaryAdminEmail = "admin2@sharepointloupe.com" New-SPContentDatabase -Name $ContentDatabase -DatabaseServer $DBServer -WebApplication $WebApplicationURL New-SPSite -Url $Site –ContentDatabase $ContentDatabase -Name $WebsiteName –Description $WebsiteDesc -Template $Template -OwnerAlias $PrimaryLogin –OwnerEmail $PrimaryEmail -SecondaryOwnerAlias $SecondaryAdminLogin -SecondaryEmail $SecondaryAdminEmail |
Here is the SharePoint 2013 Site Template ID List. Happy SharePointing!