Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Prerequisites for Migrating from Log Shipping to AlwaysOn Availability Groups (SQL Server)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

This topic describes the prerequisites for converting a log shipping primary database along with one or more of its secondary databases to an AlwaysOn primary database and secondary database(s).

Note Note

You can configure any primary or secondary database (possibly readable) in an availability group as a log shipping primary database.

In This Topic:

To allow backup jobs to run on the primary replica of the availability group, use the following AlwaysOn Availability Groups backup settings:



Automated backup preference of availability group

Only on the primary replica

Backup priority of the primary replica.


For more information:

View Availability Group Properties (SQL Server)

Configure Backup on Availability Replicas (SQL Server)

  • The log shipping primary database must reside on the instance of SQL Server that hosts the initial/current primary replica of the availability group.

  • For a given log shipping secondary database to be converted to an AlwaysOn secondary database, it must:

    • Use the same name as the primary database.

    • Reside on a server instance that hosts a secondary replica for the availability group.

Once the backup job has run on the primary database, disable the backup job, and once the restore job has run on a given secondary database, disable the restore job.

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.

For more information:

Converting a logshipping configuration to Availability Group (a SQL Server blog)

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft