Export (0) Print
Expand All

Database cmdlets in SharePoint 2013

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft