Home / Commands / New-sqmAvailabilityGroup
New-sqmAvailabilityGroup
AlwaysOn sqmSQLTool v1.8.2+
Creates an AlwaysOn Availability Group on an existing Windows Server Failover Cluster (WSFC).

Examples

New-sqmAvailabilityGroup -SqlInstance SQL01 -SecondaryReplica SQL02 `
New-sqmAvailabilityGroup -SqlInstance SQL01 -SecondaryReplica SQL02 `
        -AvailabilityGroupName ProdAG -Database AppDb `
        -ListenerName ProdAGL -ListenerIPAddress 10.0.0.50 -ListenerPort 1433 `
        -ServiceAccount 'CONTOSO\svcSql'

    Creates a two-node synchronous AG with automatic seeding and a listener.
New-sqmAvailabilityGroup -SqlInstance SQL01 -SecondaryReplica SQL02,SQL03 `
New-sqmAvailabilityGroup -SqlInstance SQL01 -SecondaryReplica SQL02,SQL03 `
        -AvailabilityGroupName ProdAG -FailoverMode Manual -BackupPreference PreferSecondary -WhatIf

    Dry-run of a three-node asynchronous AG; no changes are made.
← Previous Command
New-sqmAutoLoginSyncJob
Next Command →
Remove-sqmDatabaseFromAG