Share via


Log Shipping and AlwaysOn Availability Groups (SQL Server)

Configuring log shipping on a database that belongs to an AlwaysOn availability group requires the following:

  1. By default the automated backup preference configuration property of an availability group is set to prefer secondary replicas. Before you can configure log shipping on a database that belongs to an availability group, you must set the automated backup preference configuration property of the availability group to the primary replica, and ensure that the primary replica is a candidate for performing backups (that is, that its backup priority is >0). For more information, see Yedekleme (SQL Server) kullanılabilirliği yinelemesi üzerinde yapılandırmak.

  2. You can configure log shipping only on the current primary databases of an availability group.

  3. Configure one or more secondary log shipping databases.

    [!NOT]

    To use log shipping to prepare secondary databases for an availability group, for each of the primary databases, configure a log shipping secondary database on every server instance that hosts a secondary replica.

  4. After you have created all the secondary databases for the availability group, if you want to perform backups on secondary replicas, you need to re-configure the automated backup preference of the availability group.

To deploy log shipping

To create and configure a availability group

To configure backup on availability replicas

Ayrıca bkz.

Kavramlar

Özet sevkiyat oturum

AlwaysOn kullanılabilirlik grupları (SQL Server) genel bakış