Split-SPServerScaleOutDatabase

将指定百分比的分区从一个向外扩展数据库移动到另一个向外扩展数据库。

语法

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 cmdlet 从源数据库向现有目标数据库或向使用指定参数创建的新数据库中移动指定百分比的分区。

示例

---------------示例---------------

$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.

参数

-Confirm

提示你在运行 cmdlet 之前进行确认。

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

显示在 cmdlet 运行时发生的情况。 此 cmdlet 未运行。

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

-工作分配

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.

注意:使用全局参数时,所有对象都包含在全局存储中。 If objects are not immediately used, or disposed of by using the Stop-SPAssignment command, an out-of-memory scenario can occur.

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

输入

Microsoft.SharePoint.PowerShell.SPAssignmentCollection

输出

System.Object