< Back
Get-AzureRmSqlElasticPoolDatabase
Post
NAME Get-AzureRmSqlElasticPoolDatabase
SYNOPSIS
Gets elastic databases in an elastic pool and their property values.
SYNTAX
Get-AzureRmSqlElasticPoolDatabase [-ResourceGroupName] <String> [-ServerName] <String> [-ElasticPoolName] <String> [-DatabaseName <String>]
[-DefaultProfile <IAzureContextContainer>] [-Confirm] [-WhatIf] [<CommonParameters>]
DESCRIPTION
The Get-AzureRmSqlElasticPoolDatabase cmdlet gets elastic databases in an elastic pool and their property values. You can specify the name of an
elastic database in Azure SQL Database to see the property values for only that database.
PARAMETERS
-DatabaseName <String>
Specifies the name of the SQL Database that this cmdlet gets.
Required? false
Position? named
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-DefaultProfile <IAzureContextContainer>
The credentials, account, tenant, and subscription used for communication with azure
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-ElasticPoolName <String>
Specifies the name of an elastic pool.
Required? true
Position? 2
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ResourceGroupName <String>
Specifies the name of a resource group to which the elastic pool is assigned.
Required? true
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ServerName <String>
Specifies the name of a server that contains an elastic pool.
Required? true
Position? 1
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-Confirm [<SwitchParameter>]
Prompts you for confirmation before running the cmdlet.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-WhatIf [<SwitchParameter>]
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
None
This cmdlet does not accept any input.
OUTPUTS
Microsoft.Azure.Commands.Sql.Database.Model.AzureSqlDatabaseModel
NOTES
Example 1: Get all databases in an elastic pool
PS C:\\>Get-AzureRmSqlElasticPoolDatabase -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -ElasticPoolName "ElasticPool01"
This command gets all databases in an elastic pool named ElasticPool01.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... oldatabase
Get-AzureRmSqlElasticPool
Get-AzureRmSqlElasticPoolActivity
New-AzureRmSqlElasticPool
Remove-AzureRmSqlElasticPool
Set-AzureRmSqlElasticPool
SYNOPSIS
Gets elastic databases in an elastic pool and their property values.
SYNTAX
Get-AzureRmSqlElasticPoolDatabase [-ResourceGroupName] <String> [-ServerName] <String> [-ElasticPoolName] <String> [-DatabaseName <String>]
[-DefaultProfile <IAzureContextContainer>] [-Confirm] [-WhatIf] [<CommonParameters>]
DESCRIPTION
The Get-AzureRmSqlElasticPoolDatabase cmdlet gets elastic databases in an elastic pool and their property values. You can specify the name of an
elastic database in Azure SQL Database to see the property values for only that database.
PARAMETERS
-DatabaseName <String>
Specifies the name of the SQL Database that this cmdlet gets.
Required? false
Position? named
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-DefaultProfile <IAzureContextContainer>
The credentials, account, tenant, and subscription used for communication with azure
Required? false
Position? named
Default value None
Accept pipeline input? False
Accept wildcard characters? false
-ElasticPoolName <String>
Specifies the name of an elastic pool.
Required? true
Position? 2
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ResourceGroupName <String>
Specifies the name of a resource group to which the elastic pool is assigned.
Required? true
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ServerName <String>
Specifies the name of a server that contains an elastic pool.
Required? true
Position? 1
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-Confirm [<SwitchParameter>]
Prompts you for confirmation before running the cmdlet.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
-WhatIf [<SwitchParameter>]
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Required? false
Position? named
Default value False
Accept pipeline input? False
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216).
INPUTS
None
This cmdlet does not accept any input.
OUTPUTS
Microsoft.Azure.Commands.Sql.Database.Model.AzureSqlDatabaseModel
NOTES
Example 1: Get all databases in an elastic pool
PS C:\\>Get-AzureRmSqlElasticPoolDatabase -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -ElasticPoolName "ElasticPool01"
This command gets all databases in an elastic pool named ElasticPool01.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... oldatabase
Get-AzureRmSqlElasticPool
Get-AzureRmSqlElasticPoolActivity
New-AzureRmSqlElasticPool
Remove-AzureRmSqlElasticPool
Set-AzureRmSqlElasticPool