Set-MgmtSvcSqlHostingServer

Updates a SQL Server hosting server.

Syntax

Set-MgmtSvcSqlHostingServer [-AdminUri] <Uri> [-Token] <String> [[-HostingServer] <SqlHostingServer>]
 [-Confirm] [-DisableCertificateValidation] [-WhatIf] [<CommonParameters>]
Set-MgmtSvcSqlHostingServer [-AdminUri] <Uri> [-Token] <String> [-Name] <String> [-HostingServerId] <String>
 [[-TotalSpaceMB] <Int32>] [-Confirm] [-DisableCertificateValidation] [-MaximumResourcePools <Int32>]
 [-NumberOfCpuCores <Int32>] [-SqlUser <PSCredential>] [-SupportedIopsPerVolume <Int32>]
 [-TotalMemoryGB <Int32>] [-WhatIf] [<CommonParameters>]

Description

The Set-MgmtSvcSqlHostingServer cmdlet updates a SQL Server hosting server.

Examples

Example 1: Update a SQL hosting server

PS C:\> $Creds = Get-Credential
PS C:\> Set-MgmtSvcSqlHostingServer -AdminUri "https://Computer01:30004" -Token $Token -Name "SQLServer01.Contoso.com" -TotalSpaceMB 4096 -User $Creds -HostingServerId "u37k25"
PS C:\> Set-MgmtSvcSqlHostingServer -AdminUri "https://Computer01:30004" -Token $Token -Name "SQLServer01.Contoso.com" -TotalSpaceMB 4096 -NumberOfCpuCores 4 -TotalMemoryGB 12 -SupportedIopsPerVolume 500 -MaximumResourcePools 12 -HostingServerId "u37k25"
NOTE: This example assumes that you have created a token by using **Get-MgmtSvcToken** and have stored it in a variable named $Token. The first command prompts the user for credentials and stores the provided user name and password in the $Credential variable. The *SqlUser* parameter is only required if the hosting server's connection must be repaired. The second command updates the total space to 4096 MB for the hosting server named SQLServer01.Contoso.com. The third command updates the values of total space, CPU core, memory, supported IOPS per volume, and maximum resource pools allowed in the server.

Parameters

-AdminUri

Specifies the URI of the Windows Azure Pack administrator API.
Use the following format: https://< computer>:<port>, where <computer> is the computer on which the administrator API is installed.

Type:Uri
Required:True
Position:0
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

-Confirm

Prompts you for confirmation before running the cmdlet.

Type:SwitchParameter
Aliases:cf
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False

-DisableCertificateValidation

Disables certificate validation for the Windows Azure Pack installation.

If you specify this parameter, you can use self-signed certificates.

Type:SwitchParameter
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False

-HostingServer

Specifies a SQL Server hosting server object.

Type:SqlHostingServer
Required:False
Position:2
Default value:None
Accept pipeline input:True (ByValue)
Accept wildcard characters:False

-HostingServerId

Specifies the ID of a SQL Server hosting server.

Type:String
Required:True
Position:3
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

-MaximumResourcePools

Specifies the number of resource pools for the server.

Type:Int32
Required:False
Position:Named
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

-Name

Specifies the name of a SQL Server hosting server.

Type:String
Required:True
Position:2
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

-NumberOfCpuCores

Specifies the number of CPU cores for the server.

Type:Int32
Required:False
Position:Named
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

-SqlUser

Specifies a SQL user account and password as a PSCredential object.
To create a PSCredential object, use the Get-Credential cmdlet.

Type:PSCredential
Required:False
Position:Named
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

-SupportedIopsPerVolume

Specifies the supported I/O operations per second (IOPS) for the server.

Type:Int32
Required:False
Position:Named
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

-Token

Specifies an identity token.
To create a token, use the Get-MgmtSvcToken cmdlet.

Type:String
Required:True
Position:1
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

-TotalMemoryGB

Specifies the total amount of memory, in gigabytes, for the server.

Type:Int32
Required:False
Position:Named
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

-TotalSpaceMB

Specifies the size, in megabytes (MB) of the hosting server.

Type:Int32
Required:False
Position:3
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

-WhatIf

Shows what would happen if the cmdlet runs.
The cmdlet is not run.

Type:SwitchParameter
Aliases:wi
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False

Inputs

SqlHostingServer

You can pipe a **SqlHostingServer** object to this cmdlet.

Outputs

SqlHostingServer

This cmdlet emits a **SqlHostingServer** object.