Export (0) Print
Expand All
Expand Minimize

Set-SPScaleOutDatabaseDataRange

SharePoint 2013

Published: July 16, 2012

Applies to:  SharePoint Foundation 2013 | SharePoint Server 2013 

Extends the range of a specified scale-out database.

Set-SPScaleOutDatabaseDataRange -Database <SPDatabasePipeBind> -IsUpperSubRange <$true | $false> -Range <SPScaleOutDataRange> [-AssignmentCollection <SPAssignmentCollection>] [-Confirm [<SwitchParameter>]] [-NewRangePoint <Byte[]>] [-WhatIf [<SwitchParameter>]]

Parameters

Parameter Required Type Description

Database

Required

Microsoft.SharePoint.PowerShell.SPDatabasePipeBind

Specifies the scale-out database to which to extend the data range.

IsUpperSubRange

Required

System.Boolean

Specifies whether to set the start or the end point of the data range with the specified value in the NewRangePoint parameter.

Range

Required

Microsoft.SharePoint.SPScaleOutDataRange

Specifies the expected data range of the scale-out database.

AssignmentCollection

Optional

Microsoft.SharePoint.PowerShell.SPAssignmentCollection

Manages objects for the purpose of proper disposal. Use of objects, such as SPWeb or SPSite, can use large amounts of memory and use of these objects in Windows PowerShell scripts requires proper memory management. Using the SPAssignment object, you can assign objects to a variable and dispose of the objects after they are needed to free up memory. When SPWeb, SPSite, or SPSiteAdministration objects are used, the objects are automatically disposed of if an assignment collection or the Global parameter is not used.

noteNote:

When the Global parameter is used, all objects are contained in the global store. If objects are not immediately used, or disposed of by using the Stop-SPAssignment command, an out-of-memory scenario can occur.

Confirm

Optional

System.Management.Automation.SwitchParameter

Prompts you for confirmation before executing the command. For more information, type the following command: get-help about_commonparameters

NewRangePoint

Optional

System.Byte[]

Specifies the new start or end point of the database.

The maximum value is NULL.

WhatIf

Optional

System.Management.Automation.SwitchParameter

Displays a message that describes the effect of the command instead of executing the command. For more information, type the following command: get-help about_commonparameters

Detailed Description

Use the Set-SPScaleOutDatabaseDataRange cmdlet to extend the range of a specified scale-out database towards a specified direction.

Input Types

Return Types

--------------EXAMPLE------------

$databases = Get-SPScaleOutDatabase -ServiceApplication $serviceApplication
$database = $databases[0]
$state = Get-SPScaleOutDatabaseDataState –Database $database
Set-SPScaleOutDatabaseDataRange -Database $database -Range $state.Range -NewRangePoint $null –IsUpperSubRange $true

This example extends the data range end point of the first database in the specified service application up to the maximum range point.

Change History

Date Description

July 16, 2012

Initial publication

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