create New site collection with new content database using powershell

Question

How to create a new site collection in existing web application but with new content database using powershell.

Answer 1

You can use:

New-SPSite -Url $url –ContentDatabase $ContentDatabase -Name $WebsiteName –Description $WebsiteDesc  -Template $Template -OwnerAlias $PrimaryLogin –OwnerEmail $PrimaryEmail

see: https://social.technet.microsoft.com/forums/sharepoint/en-US/89c90032-5be1-4fe6-8546-0114eaf018ca/site-collection-in-a-particular-content-database

Answer 2

You have to create the Content Database 1st then you will be able to create new site collection.

New-SPContentDatabase -Name "database name" -DatabaseServer "database server name"  -WebApplication "web app url"

$dbname = Get-SPContentDatabase "databasename"

New-SPSite -URL $site -OwnerAlias $owner1 -SecondaryOwnerAlias $owner2 -ContentDatabase $dbname -Template "BLANKINTERNET#0"

For site template codes, please check this blog. http://www.funwithsharepoint.com/sharepoint-2013-site-templates-codes-for-powershell/