September 15, 2020 at 9:24 pm
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.
September 15, 2020 at 11:29 pm
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
September 16, 2020 at 12:59 pm
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply