Learning Microsoft Azure Storage

Adding databases to a failover group using PowerShell

First off, you will have to create a failover group by running the following cmdlet:

New-AzureRMSqlDatabaseFailoverGroup –ResourceGroupName PacktPub -ServerName packtpubsqlps -PartnerServerName packtpubsqlpssec –FailoverGroupName psfg –FailoverPolicy Automatic -GracePeriodWithDataLossHours 1 | Add-AzureRmSqlDatabaseToFailoverGroup -ResourceGroupName PacktPub -ServerName packtpubsqlps -FailoverGroupName psfg

Then, you can add the database to the failover group by running the following cmdlet:

Get-AzureRmSqlDatabase -ResourceGroupName PacktPub -ServerName packtpubsqlps -DatabaseName additionaldbps | Add-AzureRmSqlDatabaseToFailoverGroup -ResourceGroupName PacktPub -ServerName packtpubsqlps ...