Step by Step Configuring AlwaysOn with Log Shipping

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

    Regards,Ganapathi varma, MCSAEmail: gana20m@gmail.com

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

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • 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."

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

  • Can you share all the scripts?

    Thanks.

  • 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.

  • .

  • 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

  • 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

  • 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

  • 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

  • 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