Step by Step Configuring AlwaysOn with Log Shipping

  • gana20m

    SSCrazy

    Points: 2428

    Comments posted to this topic are about the item Step by Step Configuring AlwaysOn with Log Shipping

    Regards,
    Ganapathi varma, MCSA
    Email: gana20m@gmail.com

  • Perry Whittle

    SSC Guru

    Points: 233794

    No need to disable the jobs just insert a new job step at the beginning which checks whether the replica is primary or not

    -----------------------------------------------------------------------------------------------------------

    [font="Tahoma"]"Ya can't make an omelette without breaking just a few eggs"[/font] 😉

  • Caruncles

    Hall of Fame

    Points: 3239

    What version of SQL Server are you using?
    What application are we seeing in the Screenshot?  It doesn't look like SSMS (at least SSMS 2008). 
    I'm using Log Shipping but am not familiar with "Always On".   I'd like to learn about it.  
    Thanx!

    Wallace Houston
    Sunnyland Farms, Inc.

    "We must endeavor to persevere."

  • farhanchy

    SSC Rookie

    Points: 40

    Can someone please show how to set up Log Shipping with a 2 Node Active/Passive Cluster

  • SQL_Hunt

    SSC-Dedicated

    Points: 33267

    Can you share all the scripts?

    Thanks.

  • Travis Halsell

    Mr or Mrs. 500

    Points: 543

    Now when you say just the top part of the script... do you mean just the enabling the database as the logshipping database and configuring the backup job?

    Or do you have to do the full configuration? I essentially just want log backups to persists after a failover while the secondary can remain copying the log backup files and restoring them.

  • Travis Halsell

    Mr or Mrs. 500

    Points: 543

    .

  • Sue_H

    SSC Guru

    Points: 90287

    thalsell - Thursday, July 5, 2018 2:58 PM

    Now when you say just the top part of the script... do you mean just the enabling the database as the logshipping database and configuring the backup job?

    Or do you have to do the full configuration? I essentially just want log backups to persists after a failover while the secondary can remain copying the log backup files and restoring them.

    Yes...The part that is "Script to be run at the primary". Executing sp_add_log_shipping_primary_database will create the entries in the table for the primary database, including the job, on the replica. You don't need to run everything else as the share, log shipping secondary, etc would already be setup.

    Sue

  • Sue_H

    SSC Guru

    Points: 90287

    farhanchy - Thursday, April 19, 2018 12:11 PM

    Can someone please show how to set up Log Shipping with a 2 Node Active/Passive Cluster

    It's the same on a cluster as it is on a stand alone server. The only change would be adding the share for the logs as a cluster resource.

    Sue

  • VishnuGupthanSQLPowershellDBA

    SSC Eights!

    Points: 877

    Hi Ganapathi, 

    I think this line there is a typo.

    "Now we have to disable\enable any job after any AG1 fail-over between SQL1 & SQL2. ".

    It should be 'Now we do not have to disable\enable any job after any AG1 fail-over between SQL1 & SQL2. '
    Please correct me if am wrong. 

    Vishnu

  • farhanchy

    SSC Rookie

    Points: 40

    Sue_H - Thursday, July 5, 2018 3:46 PM

    thalsell - Thursday, July 5, 2018 2:58 PM

    Now when you say just the top part of the script... do you mean just the enabling the database as the logshipping database and configuring the backup job?

    Or do you have to do the full configuration? I essentially just want log backups to persists after a failover while the secondary can remain copying the log backup files and restoring them.

    Yes...The part that is "Script to be run at the primary". Executing sp_add_log_shipping_primary_database will create the entries in the table for the primary database, including the job, on the replica. You don't need to run everything else as the share, log shipping secondary, etc would already be setup.

    Sue

    Sue_H - Thursday, July 5, 2018 3:46 PM

    thalsell - Thursday, July 5, 2018 2:58 PM

    Now when you say just the top part of the script... do you mean just the enabling the database as the logshipping database and configuring the backup job?

    Or do you have to do the full configuration? I essentially just want log backups to persists after a failover while the secondary can remain copying the log backup files and restoring them.

    Yes...The part that is "Script to be run at the primary". Executing sp_add_log_shipping_primary_database will create the entries in the table for the primary database, including the job, on the replica. You don't need to run everything else as the share, log shipping secondary, etc would already be setup.

    Sue

    Sue_H - Thursday, July 5, 2018 3:48 PM

    farhanchy - Thursday, April 19, 2018 12:11 PM

    Can someone please show how to set up Log Shipping with a 2 Node Active/Passive Cluster

    It's the same on a cluster as it is on a stand alone server. The only change would be adding the share for the logs as a cluster resource.

    If my back up goes to a network share then is there any need to add the cluster resource

  • khautinh 30771

    Newbie

    Points: 1

    Hi There,

    Thanks for the post.  I could follow and configure the processes.   My question is if I have full backup on the AlwaysOn, I have re-initiate the log shipping.  do you run across it?  if you do, is there anything better idea?

    Thanks.

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

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