< Back
Add-AzureRmSqlDatabaseToFailoverGroup
Post
NAME Add-AzureRmSqlDatabaseToFailoverGroup
SYNOPSIS
Adds one or more databases to an Azure SQL Database Failover Group.
SYNTAX
Add-AzureRmSqlDatabaseToFailoverGroup [-ResourceGroupName] <String> [-ServerName] <String> [-FailoverGroupName] <String> -Database
<System.Collections.Generic.List`1[Microsoft.Azure.Commands.Sql.Database.Model.AzureSqlDatabaseModel]> [-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
DESCRIPTION
Adds one or more databases on a Azure SQL Database Failover Group's primary server to to that Failover Group. The databases must not be secondary
databases in existing replication relationships. The command will start geo-replication of any added databases to the Failover Group's secondary
server.
To obtain database objects with which to populate the '-Database' parameter, use (for example) the Get-AzureRmSqlDatabase cmdlet.
The Failover Group's primary server must be used to execute the command.
PARAMETERS
-Database <System.Collections.Generic.List`1[Microsoft.Azure.Commands.Sql.Database.Model.AzureSqlDatabaseModel]>
One or more Azure SQL Databases on the Failover Group's primary server to be added to the Failover Group.
Required? true
Position? named
Default value None
Accept pipeline input? True (ByValue)
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
-FailoverGroupName <String>
The name of the Azure SQL Database Failover Group.
Required? true
Position? 2
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ResourceGroupName <String>
The name of the resource group.
Required? true
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ServerName <String>
The name of the primary Azure SQL Database Server of the Failover Group.
Required? true
Position? 1
Default value None
Accept pipeline input? True (ByPropertyName)
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
System.String
System.Collections.Generic.List`1[[Microsoft.Azure.Commands.Sql.Database.Model.AzureSqlDatabaseModel, Microsoft.Azure.Commands.Sql,
Version=2.5.0.0, Culture=neutral, PublicKeyToken=null]]
OUTPUTS
System.Object
NOTES
Example 1
PS C:\\> $failoverGroup = Get-AzureRmSqlDatabase -ResourceGroupName rg -ServerName primaryserver -DatabaseName db1 |
Add-AzureRmSqlDatabaseToFailoverGroup -ResourceGroupName rg -ServerName primaryserver -FailoverGroupName fg
This command adds one database to a Failover Group by piping it in.
Example 2
PS C:\\> $primaryServer = Get-AzureRmSqlServer -ResourceGroupName rg -ServerName primaryserver
PS C:\\> $failoverGroup = $primaryServer | Add-AzureRmSqlDatabaseToFailoverGroup -FailoverGroupName fg -Database ($primaryServer |
Get-AzureRmSqlDatabase)
This command adds all databases in a server to a Failover Group.
Example 3
PS C:\\> $failoverGroup = Get-AzureRmSqlDatabaseFailoverGroup -ResourceGroupName rg -ServerName primaryserver -FailoverGroupName fg
PS C:\\> $databases = Get-AzureRmSqlElasticPoolDatabase -ResourceGroupName rg -ServerName primaryserver -ElasticPoolName pool1
PS C:\\> $failoverGroup = $failoverGroup | Add-AzureRmSqlDatabaseToFailoverGroup -Database $databases
This command adds all databases in an Elastic Pool to a Failover Group.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... lovergroup
New-AzureRmSqlDatabaseFailoverGroup
Set-AzureRmSqlDatabaseFailoverGroup
Get-AzureRmSqlDatabaseFailoverGroup
Remove-AzureRmSqlDatabaseFromFailoverGroup
Switch-AzureRmSqlDatabaseFailoverGroup
Remove-AzureRmSqlDatabaseFailoverGroup
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/
SYNOPSIS
Adds one or more databases to an Azure SQL Database Failover Group.
SYNTAX
Add-AzureRmSqlDatabaseToFailoverGroup [-ResourceGroupName] <String> [-ServerName] <String> [-FailoverGroupName] <String> -Database
<System.Collections.Generic.List`1[Microsoft.Azure.Commands.Sql.Database.Model.AzureSqlDatabaseModel]> [-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
DESCRIPTION
Adds one or more databases on a Azure SQL Database Failover Group's primary server to to that Failover Group. The databases must not be secondary
databases in existing replication relationships. The command will start geo-replication of any added databases to the Failover Group's secondary
server.
To obtain database objects with which to populate the '-Database' parameter, use (for example) the Get-AzureRmSqlDatabase cmdlet.
The Failover Group's primary server must be used to execute the command.
PARAMETERS
-Database <System.Collections.Generic.List`1[Microsoft.Azure.Commands.Sql.Database.Model.AzureSqlDatabaseModel]>
One or more Azure SQL Databases on the Failover Group's primary server to be added to the Failover Group.
Required? true
Position? named
Default value None
Accept pipeline input? True (ByValue)
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
-FailoverGroupName <String>
The name of the Azure SQL Database Failover Group.
Required? true
Position? 2
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ResourceGroupName <String>
The name of the resource group.
Required? true
Position? 0
Default value None
Accept pipeline input? True (ByPropertyName)
Accept wildcard characters? false
-ServerName <String>
The name of the primary Azure SQL Database Server of the Failover Group.
Required? true
Position? 1
Default value None
Accept pipeline input? True (ByPropertyName)
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
System.String
System.Collections.Generic.List`1[[Microsoft.Azure.Commands.Sql.Database.Model.AzureSqlDatabaseModel, Microsoft.Azure.Commands.Sql,
Version=2.5.0.0, Culture=neutral, PublicKeyToken=null]]
OUTPUTS
System.Object
NOTES
Example 1
PS C:\\> $failoverGroup = Get-AzureRmSqlDatabase -ResourceGroupName rg -ServerName primaryserver -DatabaseName db1 |
Add-AzureRmSqlDatabaseToFailoverGroup -ResourceGroupName rg -ServerName primaryserver -FailoverGroupName fg
This command adds one database to a Failover Group by piping it in.
Example 2
PS C:\\> $primaryServer = Get-AzureRmSqlServer -ResourceGroupName rg -ServerName primaryserver
PS C:\\> $failoverGroup = $primaryServer | Add-AzureRmSqlDatabaseToFailoverGroup -FailoverGroupName fg -Database ($primaryServer |
Get-AzureRmSqlDatabase)
This command adds all databases in a server to a Failover Group.
Example 3
PS C:\\> $failoverGroup = Get-AzureRmSqlDatabaseFailoverGroup -ResourceGroupName rg -ServerName primaryserver -FailoverGroupName fg
PS C:\\> $databases = Get-AzureRmSqlElasticPoolDatabase -ResourceGroupName rg -ServerName primaryserver -ElasticPoolName pool1
PS C:\\> $failoverGroup = $failoverGroup | Add-AzureRmSqlDatabaseToFailoverGroup -Database $databases
This command adds all databases in an Elastic Pool to a Failover Group.
RELATED LINKS
Online Version: https://docs.microsoft.com/en-us/powers ... lovergroup
New-AzureRmSqlDatabaseFailoverGroup
Set-AzureRmSqlDatabaseFailoverGroup
Get-AzureRmSqlDatabaseFailoverGroup
Remove-AzureRmSqlDatabaseFromFailoverGroup
Switch-AzureRmSqlDatabaseFailoverGroup
Remove-AzureRmSqlDatabaseFailoverGroup
SQL Database Documentation https://docs.microsoft.com/azure/sql-database/