If you have a requirement where you need to Create a Site Collection in New Content Database, refer following PowerShell Script:
add-pssnapin Microsoft.SharePoint.PowerShell
$url = "http://sitecollection_link"
$ContentDatabase = "Content_DB_Name"
$WebsiteName = "New Site
Collection Title"
$WebsiteDesc = "New Site
Collection Description"
$Template = "STS#0" #It
is for team site (use STS#1 for blank site)
$PrimaryLogin = "Domain\username1"
$SecondaryLogin = "Domain\username2"
New-SPSite -Url $url –ContentDatabase
$ContentDatabase -Name
$WebsiteName –Description
$WebsiteDesc -Template $Template -OwnerAlias
$PrimaryLogin -SecondaryOwnerAlias
$SecondaryLogin
Following script will create new content database and create site collection in newly created database. It is with parameters and also handles errors, so looks little longer :P
add-pssnapin Microsoft.SharePoint.PowerShell
#Set following parameters
$WebsiteName = "Test
Site"
#Verify following parameters
$DbServer = "SQLServer"
$WebAppUrl = "http://webapplink"
#Uncomment if you are using managed path
#$ManagedPath = "path"
$DBName = "WSS_Content_" +
$WebsiteName
$PrimaryLogin = "Domain\UserName"
$SecondaryLogin = "Domain\UserName"
$MaxSiteCount = 1
$WarningSiteCount = 0
$ContentDatabase = $null
#Create new content database
try
{
$ContentDatabase
= Get-SPContentDatabase
$DBName -ErrorAction
ignore
if($ContentDatabase -eq
$null)
{
New-SPContentDatabase
-Name $DBName
-DatabaseServer $DbServer
-WebApplication $WebAppUrl -MaxSiteCount $MaxSiteCount -WarningSiteCount $WarningSiteCount
-ErrorAction Stop
Write-Host
"Database Created Successfully" -ForegroundColor Green
$ContentDatabase
= Get-SPContentDatabase
$DBName
}
else
{
Write-Host
"Database already exist." -ForegroundColor Red
}
#Set
Parameters
$url = $WebAppUrl
+ "/sites/"
+$WebsiteName
#Uncomment if
you are using managed path
#$url =
$WebAppUrl + "/" + $ManagedPath + "/" +$WebsiteName
$WebsiteDesc
= "FieldDocs
for year " +$WebsiteName
$Template
= "STS#1"
#Create new
site collection
try
{
$site= $null
$site
= Get-SPSite
$url -ErrorAction
ignore
if($site -eq $null)
{
New-SPSite
-Url $url –ContentDatabase $ContentDatabase
-Name $WebsiteName
–Description $WebsiteDesc -Template $Template -OwnerAlias
$PrimaryLogin -SecondaryOwnerAlias
$SecondaryLogin -ErrorAction
Stop
Write-Host
"Site Collection Created Successfully"
-ForegroundColor Green
}
else
{
Write-Host
"Site Collection already exist." -ForegroundColor Red
$site.Dispose()
}
}
catch
{
Write-Host
"Error in site collection creation"
-ForegroundColor Red
}
}
catch
{
Write-Host "Error in database creation" -ForegroundColor Red
}
