SPContentDatabase

Parameters

Parameter	Attribute	DataType	Description	Allowed Values
Name	Key	String	Specifies the name of the content database
DatabaseServer	Write	string	The name of the database server to host the content DB
WebAppUrl	Required	string	The URL of the web application
Enabled	Write	Boolean	Should the database be enabled
WarningSiteCount	Write	Uint16	Specify the site collection warning limit for the content database
MaximumSiteCount	Write	Uint16	Specify the site collection maximum limit for the content database
Ensure	Write	string	Present to create this database, absent to ensure it does not exist	Present, Absent
InstallAccount	Write	String	POWERSHELL 4 ONLY: The account to run this resource as, use PsDscRunAsAccount if using PowerShell 5

Description

This resource is used to add and remove Content Databases to web applications and and configure these databases. Note: The resource cannot be used to move the database to a different SQL instance. It will throw an error when it detects that the specified SQL instance is a different instance that is currently in use.

Example

SPContentDatabase ContentDB {
    Name = "SharePoint_Content_01"
    DatabaseServer = "SQL.contoso.local\SQLINSTANCE"
    WebAppUrl = "http://sharepoint.contoso.com"
    Enabled = $true
    WarningSiteCount = 2000
    MaximumSiteCount = 5000
    Ensure = "Present"
    PsDscRunAsCredential = $InstallAccount
}