Step by Step Configuring AlwaysOn with Log Shipping

Question

Step by Step Configuring AlwaysOn with Log Shipping

gana20m

SSCrazy

Points: 2443
More actions
April 2, 2017 at 7:16 pm

#401886

Comments posted to this topic are about the item Step by Step Configuring AlwaysOn with Log Shipping
Regards,Ganapathi varma, MCSAEmail: gana20m@gmail.com

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

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

Perry Whittle SSC Guru Points: 234013 More actions · Answer 1

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" 😉

Caruncles Hall of Fame Points: 3299 More actions · Answer 2

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 More actions · Answer 3

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

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 4

SQL_Hunt

SSC-Dedicated

Points: 33518

June 5, 2018 at 12:44 pm

#1993004

Can you share all the scripts?

Thanks.

Travis Halsell SSC Eights! Points: 896 More actions · Answer 5

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 SSC Eights! Points: 896 More actions · Answer 6

Travis Halsell

SSC Eights!

Points: 896

July 5, 2018 at 3:20 pm

#1996462

.

Sue_H SSC Guru Points: 90860 More actions · Answer 7

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: 90860 More actions · Answer 8

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 Ten Centuries Points: 1230 More actions · Answer 9

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

Vishnu Gupthan
PowershellAcademy
www.powershellacademy.com

farhanchy SSC Rookie Points: 40 More actions · Answer 10

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 More actions · Answer 11

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.