Share via


az sql db replica

Manage replication between databases.

Commands

Name Description Type Status
az sql db replica create

Create a database as a readable secondary replica of an existing database.

Core GA
az sql db replica delete-link

Permanently stop data replication between two database replicas.

Core GA
az sql db replica list-links

List the replicas of a database and their replication status.

Core GA
az sql db replica set-primary

Set the primary replica database by failing over from the current primary replica database.

Core GA

az sql db replica create

Create a database as a readable secondary replica of an existing database.

A full list of performance level options can be seen by executing az sql db list-editions -a -o table -l LOCATION. The secondary database must have the same edition as the primary database.

az sql db replica create --name
                         --partner-server
                         --resource-group
                         --server
                         [--assign-identity {false, true}]
                         [--auto-pause-delay]
                         [--availability-zone]
                         [--backup-storage-redundancy]
                         [--capacity]
                         [--compute-model {Provisioned, Serverless}]
                         [--elastic-pool]
                         [--encryption-protector]
                         [--encryption-protector-auto-rotation {false, true}]
                         [--family]
                         [--federated-client-id]
                         [--ha-replicas]
                         [--keys]
                         [--license-type {BasePrice, LicenseIncluded}]
                         [--min-capacity]
                         [--no-wait]
                         [--partner-database]
                         [--partner-resource-group]
                         [--preferred-enclave-type {Default, VBS}]
                         [--read-scale {Disabled, Enabled}]
                         [--secondary-type]
                         [--service-level-objective]
                         [--tags]
                         [--umi]
                         [--zone-redundant {false, true}]

Examples

Create a database with performance level S0 as a secondary replica of an existing Standard database.

az sql db replica create -g mygroup -s myserver -n originalDb --partner-server newDb --service-objective S0

Create a database with GeneralPurpose edition, Gen4 hardware, and 1 vcore as a secondary replica of an existing GeneralPurpose database

az sql db replica create -g mygroup -s myserver -n originalDb --partner-server newDb -f Gen4 -c 1

Create a database with with zone redundant backup storage as a secondary replica of an existing database.

az sql db replica create -g mygroup -s myserver -n originalDb --partner-server newDb --backup-storage-redundancy Zone

Required Parameters

--name -n

Name of the Azure SQL Database.

--partner-server

Name of the server to create the new replica in.

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

--server -s

Name of the Azure SQL Server. You can configure the default using az configure --defaults sql-server=<name>.

Optional Parameters

--assign-identity -i

Assign identity for database.

Accepted values: false, true
--auto-pause-delay

Time in minutes after which database is automatically paused. A value of -1 means that automatic pause is disabled.

--availability-zone

Availability zone.

--backup-storage-redundancy --bsr

Backup storage redundancy used to store backups. Allowed values include: Local, Zone, Geo, GeoZone.

--capacity -c

The capacity component of the sku in integer number of DTUs or vcores.

--compute-model

The compute model of the database.

Accepted values: Provisioned, Serverless
--elastic-pool

The name or resource id of the elastic pool to create the database in.

--encryption-protector

Specifies the Azure key vault key to be used as database encryption protector key.

--encryption-protector-auto-rotation --epauto

Specifies the database encryption protector key auto rotation flag. Can be either true, false or null.

Accepted values: false, true
--family -f

The compute generation component of the sku (for vcore skus only). Allowed values include: Gen4, Gen5.

--federated-client-id

The federated client id for the SQL Database. It is used for cross tenant CMK scenario.

--ha-replicas --read-replicas

The number of high availability replicas to provision for the database. Only settable for Hyperscale edition.

--keys

The list of AKV keys for the SQL Database.

--license-type

The license type to apply for this database.LicenseIncluded if you need a license, or BasePriceif you have a license and are eligible for the Azure HybridBenefit.

Accepted values: BasePrice, LicenseIncluded
--min-capacity

Minimal capacity that database will always have allocated, if not paused.

--no-wait

Do not wait for the long-running operation to finish.

Default value: False
--partner-database

Name of the new replica. If unspecified, defaults to the source database name.

--partner-resource-group

Name of the resource group to create the new replica in. If unspecified, defaults to the origin resource group.

--preferred-enclave-type

Specifies type of enclave for this resource.

Accepted values: Default, VBS
--read-scale

If enabled, connections that have application intent set to readonly in their connection string may be routed to a readonly secondary replica. This property is only settable for Premium and Business Critical databases.

Accepted values: Disabled, Enabled
--secondary-type

Type of secondary to create. Allowed values include: Geo, Named.

--service-level-objective --service-objective

The service objective for the new database. For example: Basic, S0, P1, GP_Gen4_1, GP_S_Gen5_8, BC_Gen5_2, HS_Gen5_32.

--tags

Space-separated tags: key[=value] [key[=value] ...]. Use "" to clear existing tags.

--umi --user-assigned-identity-id

The list of user assigned identity for the SQL Database.

--zone-redundant -z

Specifies whether to enable zone redundancy. Default is true if no value is specified.

Accepted values: false, true
Global Parameters
--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

--output -o

Output format.

Accepted values: json, jsonc, none, table, tsv, yaml, yamlc
Default value: json
--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

Permanently stop data replication between two database replicas.

az sql db replica delete-link --partner-server
                              [--ids]
                              [--name]
                              [--partner-resource-group]
                              [--resource-group]
                              [--server]
                              [--subscription]
                              [--yes]
--partner-server

Name of the server that the other replica is in.

--ids

One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.

--name -n

Name of the Azure SQL Database.

--partner-resource-group

Name of the resource group that the other replica is in. If unspecified, defaults to the first database's resource group.

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

--server -s

Name of the Azure SQL Server. You can configure the default using az configure --defaults sql-server=<name>.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

--yes -y

Do not prompt for confirmation.

Default value: False
Global Parameters
--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

--output -o

Output format.

Accepted values: json, jsonc, none, table, tsv, yaml, yamlc
Default value: json
--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

List the replicas of a database and their replication status.

az sql db replica list-links [--ids]
                             [--name]
                             [--resource-group]
                             [--server]
                             [--subscription]

List the replicas of a database and their replication status. (autogenerated)

az sql db replica list-links --name MyAzureSQLDatabase --resource-group MyResourceGroup --server myserver
--ids

One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.

--name -n

Name of the Azure SQL Database.

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

--server -s

Name of the Azure SQL Server. You can configure the default using az configure --defaults sql-server=<name>.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

Global Parameters
--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

--output -o

Output format.

Accepted values: json, jsonc, none, table, tsv, yaml, yamlc
Default value: json
--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

az sql db replica set-primary

Set the primary replica database by failing over from the current primary replica database.

az sql db replica set-primary [--allow-data-loss]
                              [--ids]
                              [--name]
                              [--resource-group]
                              [--server]
                              [--subscription]

Examples

Set the primary replica database by failing over from the current primary replica database. (autogenerated)

az sql db replica set-primary --allow-data-loss --name MyDatabase --resource-group MyResourceGroup --server myserver --subscription MySubscription

Optional Parameters

--allow-data-loss

If specified, the failover operation will allow data loss.

Default value: False
--ids

One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.

--name -n

Name of the database to fail over.

--resource-group -g

Name of the resource group containing the secondary replica that will become the new primary.

--server -s

Name of the server containing the secondary replica that will become the new primary. You can configure the default using az configure --defaults sql-server=<name>.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

Global Parameters
--debug

Increase logging verbosity to show all debug logs.

--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

--output -o

Output format.

Accepted values: json, jsonc, none, table, tsv, yaml, yamlc
Default value: json
--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.