Get-​Azure​Sql​Database​Server

Gets information about Azure SQL Database servers.

Syntax

Get-AzureSqlDatabaseServer
   [-Profile <AzureSMProfile>]
   [-ServerName <String>]
   [<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.

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

Type:AzureSMProfile
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-ServerName

Specifies the name of the server that this cmdlet removes. Specify the server name, not the fully qualified DNS name.

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

Inputs

Microsoft.WindowsAzure.Commands.SqlDatabase.Model.SqlDatabaseServerContext

Outputs

IEnumerable\<Microsoft.WindowsAzure.Commands.SqlDatabase.Model.SqlDatabaseServerContext\>