Get-AzureSqlDatabaseServer

Reference

Module:: Azure

Gets information about Azure SQL Database servers.

Note

The cmdlets referenced in this documentation are for managing legacy Azure resources that use Service Management APIs. See the Az PowerShell module for cmdlets to manage Azure Resource Manager resources.

Syntax

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.

Type:	AzureSMProfile
Position:	Named
Default value:	None
Required:	False
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
Required:	False
Accept pipeline input:	True
Accept wildcard characters:	False

Inputs

Microsoft.WindowsAzure.Commands.SqlDatabase.Model.SqlDatabaseServerContext

Outputs

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