This topic has not yet been rated - Rate this topic

Database cmdlets in SharePoint 2013

SharePoint 2013

Other Versions

SharePoint 2010

Published: July 16, 2012

Summary: Lists Windows PowerShell cmdlets that enable you to manage databases in SharePoint 2013.

Applies to: SharePoint Foundation 2013 | SharePoint Server 2013 Standard | SharePoint Server 2013 Enterprise

You can use Windows PowerShell cmdlets to manage databases in a SharePoint 2013 farm.

Index of Windows PowerShell cmdlets for SharePoint 2013 includes a complete list of all cmdlets in SharePoint 2013.

Cmdlet name	Description
Connect-SPConfigurationDatabase	Connects the local server computer to a farm.
Disconnect-SPConfigurationDatabase	Disconnects the local server computer from the farm.
Move-SPBlobStorageLocation	Copies a content database by using Remote BLOB Storage (RBS).
New-SPConfigurationDatabase	Creates a new configuration database.
Remove-SPConfigurationDatabase	Permanently removes a configuration database.
Dismount-SPContentDatabase	Detaches a content database from the web application it is currently associated with.
Get-SPContentDatabase	Returns one or more content databases.
Mount-SPContentDatabase	Attaches an existing content database to the farm.
New-SPContentDatabase	Creates a new content database and attaches it to the specified web application.
Remove-SPContentDatabase	Deletes a content database.
Set-SPContentDatabase	Sets global properties of a SharePoint content database.
Test-SPContentDatabase	Tests a content database.
Get-SPDatabase	Retrieves all properties of a database.
Split-SPScaleOutDatabase	Moves a specified percentage of partitions from one scale-out database to another.
Set-SPScaleOutDatabaseDataRange	Extends the range of a specified scale-out database.
Set-SPScaleOutDatabaseDataSubRange	Creates a subrange for a specified scale-out database.
Remove-SPScaleOutDatabase	Removes a specific scale-out database.
Import-SPScaleOutDatabaseTenantData	Imports data from the specified subscription id.
Get-SPScaleOutDatabaseLogEntry	Queries a scale-out database for scale-out logs.
Get-SPScaleOutDatabaseInconsistency	Displays all inconsistencies related to scale-out databases' ranges.
Get-SPScaleOutDatabaseDataState	Returns the state information about the specified scale-out database.
Get-SPScaleOutDatabase	Returns all scale-out database objects.
Export-SPScaleOutDatabaseTenantData	Exports the data of the specified subscription.
Clear-SPScaleOutDatabaseTenantData	Removes all data related to the specified site subscription.
Clear-SPScaleOutDatabaseLog	Clears all scale-out logs.
Clear-SPScaleOutDatabaseDeletedDataSubRange	Clears all partitions inside the specified deleted subrange.
Add-SPScaleOutDatabase	Adds an existing scale-out database to the specified service application.
Add-SPServerScaleOutDatabase	Adds an existing scale-out database to the specified service application.
Clear-SPServerScaleOutDatabaseDeletedDataSubRange	Clears all partitions inside the specified deleted subrange.
Clear-SPServerScaleOutDatabaseLog	Clears all scale-out logs.
Clear-SPServerScaleOutDatabaseTenantData	Removes all data related to the specified site subscription.
Export-SPServerScaleOutDatabaseTenantData	Exports the data of the specified subscription.
Get-SPServerScaleOutDatabase	Returns all scale-out database objects.
Get-SPServerScaleOutDatabaseDataState	Returns the state information about the specified scale-out database.
Get-SPServerScaleOutDatabaseInconsistency	Displays all inconsistencies related to scale-out databases' ranges.
Get-SPServerScaleOutDatabaseLogEntry	Queries a scale-out database for scale-out logs.
Import-SPServerScaleOutDatabaseTenantData	Imports data from the specified subscription id.
Remove-SPServerScaleOutDatabase	Removes a specific scale-out database.
Set-SPServerScaleOutDatabaseDataRange	Extends the range of a specified scale-out database.
Set-SPServerScaleOutDatabaseDataSubRange	Creates a subrange for a specified scale-out database.
Split-SPServerScaleOutDatabase	Moves a specified percentage of partitions from one scale-out database to another.