Log Shipping into an Availability Group

  • fodderoh

    Grasshopper

    Points: 12

    I have a database I need to migrate to a new environment that is being built. The current environment does not leverage Availability Groups, but the new environment I need to migrate the database in to does use an AG.

    I need to set up log shipping for the database to facilitate the migration and this is the first time I will have set up log shipping in this particular scenario. Can you log ship in to an availability group? Or do I need to log ship in to each node of the cluster and then configure the AG after the cutover?

    Thanks.

  • James Rossi

    Grasshopper

    Points: 21

    Hi fodderoh,

    Just log ship to the primary replica of the AG.  However, you can't add it as a AG replica database just yet.

    You first have to break the log shipping process and set the database out of recovery.  Then from there you can add it to the AG replica database.

    *** Please network with me and feel free to IM if you have any more DBA questions and concerns

    https://www.linkedin.com/in/james-rossi-9094651b7/

    james rossi
    Senior SQL Server DBA
    Senior Software Developer
    Alpha One Data
    Brain Box SQL Mobile DBA

  • Cebisa

    SSC Rookie

    Points: 40

    How big is your database? Youu could log ship to both replicas.

    After bringing database online on the primary, do an xlog backup and restore that on the secondary. It speeds up the step of adding the database to the AG

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply