Split-SPServerScaleOutDatabase

1 つのスケールアウト データベースから別のスケールアウト データベースに、指定したパーセンテージのパーティションを移動します。

構文

Split-SPServerScaleOutDatabase
     -NewDatabaseName <String>
     -SourceDatabase <SPDatabasePipeBind>
     -SourceServiceApplication <SPServiceApplicationPipeBind>
     [-AssignmentCollection <SPAssignmentCollection>]
     [-Confirm]
     [-MoveLowerHalf]
     [-NewDatabaseCredentials <PSCredential>]
     [-NewDatabaseFailoverServer <String>]
     [-NewDatabaseServer <String>]
     [-SourcePercentage <Int32>]
     [-WhatIf]
     [<CommonParameters>]
Split-SPServerScaleOutDatabase
     -SourceDatabase <SPDatabasePipeBind>
     -SourceServiceApplication <SPServiceApplicationPipeBind>
     -TargetDatabase <SPDatabasePipeBind>
     [-AssignmentCollection <SPAssignmentCollection>]
     [-Confirm]
     [-MoveLowerHalf]
     [-SourcePercentage <Int32>]
     [-WhatIf]
     [<CommonParameters>]

説明

This cmdlet contains more than one parameter set. You may only use parameters from one parameter set, and you may not combine parameters from different parameter sets. For more information about how to use parameter sets, see Cmdlet Parameter Sets.

指定したパーセンテージのパーティションを、移動元データベースから既存の移動先データベース、または指定したパラメーターを含む、新しく作成したデータベースに移動するには、Split-SPServerScaleOutDatabase コマンドレットを使用します。

---------------例---------------

$databases = Get-SPServerScaleOutDatabase -ServiceApplication $serviceApplication
$database = $databases[0]
Split-SPServerScaleOutDatabase -NewDatabaseName Database2 -NewDatabaseServer MyDatabaseServer -SourceDatabase $database -SourceServiceApplication $serviceApplication -SourcePercentage 30

This example creates a new scale-out database named Database2 on the MyDatabaseServer database server in the given service application. The example also moves 30 percent of the data from the upper side of the data range in the first scale-out database of the given service application.

パラメーター

-AssignmentCollection

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.

注: Global パラメーターを使用すると、すべてのオブジェクトがグローバル ストアに格納されます。 Stop-SPAssignment コマンドを使用してオブジェクトの使用または破棄を直接行わないと、メモリ不足のシナリオになる場合があります。

Type:SPAssignmentCollection
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
Applies to:SharePoint Server Subscription Edition

-Confirm

コマンドレットを実行する前に確認メッセージを表示します。

Type:SwitchParameter
Aliases:cf
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server Subscription Edition

-MoveLowerHalf

Specifies whether to move the lower or the upper side of the data range from the source scale-out database. If this parameter is not specified, the default behavior is to move the upper side of the source scale-out database data range.

Type:SwitchParameter
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server Subscription Edition

-NewDatabaseCredentials

Specifies the credentials to use when creating the scale-out database. These credentials will have owner permissions on the new scale-out database. If you do not provide a value, the credentials of the logged on user will be used.

Type:PSCredential
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server Subscription Edition

-NewDatabaseFailoverServer

Specifies the failover server name of the new scale-out database. If you do not provide a value, the new scale-out database does not have a failover server.

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server Subscription Edition

-NewDatabaseName

新しく作成するスケールアウト データベースの名前を指定します。

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server Subscription Edition

-NewDatabaseServer

Specifies the name of the server of the new scale-out database. If you do not provide a value, the name of the default database server is used.

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server Subscription Edition

-SourceDatabase

データの移動元のスケールアウト データベース。

Type:SPDatabasePipeBind
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server Subscription Edition

-SourcePercentage

Specifies the percentage of data in the source scale-out database to move. If you do not provide a value, the default value, 50 percent, is used.

Type:Int32
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server Subscription Edition

-SourceServiceApplication

データの移動が行われるサービス アプリケーション。

Type:SPServiceApplicationPipeBind
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server Subscription Edition

-TargetDatabase

データの移動先のスケールアウト データベース。

Type:SPDatabasePipeBind
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server Subscription Edition

-WhatIf

コマンドレットが実行されるとどうなるかを示します。 コマンドレットは実行されません。

Type:SwitchParameter
Aliases:wi
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
Applies to:SharePoint Server Subscription Edition

入力

Microsoft.SharePoint.PowerShell.SPAssignmentCollection

出力

System.Object