Create SharePoint Content Database

createspcontentdatabase.ps1

Write-Host "===============================================" -ForegroundColor Yellow
Write-Host " Create SharePoint Content-Databases " -ForegroundColor Yellow
Write-Host "===============================================" -ForegroundColor Yellow
 
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

#Site to Create
$Site = 100 

#Site per SPContentDatabase
$SiteInDatabase = 20

#SharePoint WebApplication
$Application = "http://spbizerba01-dev:2408/"

#SharePoint DatabaseServer
$DatabaseServer = "spserver"

#Databasename
$ContentDatabaseNaming = "WSS_Content_"

$SPDatabases = [System.Math]::Ceiling($Site/$SiteInDatabase) 

for ($i=1; $i -le $SPDatabases; $i++)
{

$databasename = [string]::Format("$ContentDatabaseNameing{0:d4}", $i)
$waringlevel = $SiteInDatabase - 3;

Write-Host "Create Database: $databasename" -ForegroundColor Green
New-SPContentDatabase $databasename -DatabaseServer $DatabaseServer -MaxSiteCount $SiteInDatabase -WarningSiteCount $waringlevel  -WebApplication $Application

}