Get-AzureSqlDatabaseServer
Gets information about Azure SQL Database servers.
Note
The cmdlets referenced in this documentation are for managing legacy Azure resources that use Azure Service Manager (ASM) APIs. This legacy PowerShell module isn't recommended when creating new resources since ASM is scheduled for retirement. For more information, see Azure Service Manager retirement.
The Az PowerShell module is the recommended PowerShell module for managing Azure Resource Manager (ARM) resources with PowerShell.
Syntax
Default (Default)
Get-AzureSqlDatabaseServer
[-ServerName <String>]
[-Profile <AzureSMProfile>]
[<CommonParameters>]
Description
The Get-AzureSqlDatabaseServer cmdlet gets information about the instances of Azure SQL Database Server in the current subscription. If you specify a server by name, this cmdlet returns an object that contains information about that server. Otherwise, the cmdlet returns information about all the servers.
Examples
Example 1: Get information about all servers
PS C:\> Get-AzureSqlDatabaseServer
This command returns information about all instances of Azure SQL Database Server in the current subscription.
Example 2: Get information about a specific server
PS C:\> Get-AzureSqlDatabaseServer -ServerName "lpqd0zbr8y"
This command returns information about the server named lpqd0zbr8y.
Parameters
-Profile
Specifies the Azure profile from which this cmdlet reads. If you do not specify a profile, this cmdlet reads from the local default profile.
Parameter properties
| Type: | AzureSMProfile |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-ServerName
Specifies the name of the server that this cmdlet removes. Specify the server name, not the fully qualified DNS name.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | True |
| Value from remaining arguments: | False |
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.