cancel
Showing results for 
Search instead for 
Did you mean: 

Transaction Log Shipping during apply SPS Update

former_member185257
Participant
0 Kudos
249

Hi Experts,

We have ECC production system installed on Windows OS and MSSQL Server Database and in DR side log shipping is running.

Now we want to update SPS through SPAM. My question is "As the log shipping is running, so if we update SPS in ECC system then will it update in the DR database too? or we have backup and restore the DR database separately."

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

BJarkowski
Active Contributor
0 Kudos

Yes, with log shipping enabled all changes will be applied to DR database as well. You still need to take care of upgrading any components that are deployed directly to the operating system (like the kernel) - but that's not case as you're using SPAM.

Depending on the set up, the log shipping can also influence the performance as the amount of data may be quite large. Consider disabling it in case of performance issues.

Answers (3)

Answers (3)

former_member185257
Participant
0 Kudos

Thanks Diego. We will stop replica and start it after upgrade.

Many thanks for your suggesstion.

hrollizo
Active Participant
0 Kudos

Yes,

when you apply SPS using SPAM/SUM, all changes will be applied into database and in your case, into your Secundary node too. The SAP kernel change only use local space resources.

You can schedule more transaction logs backups beforehand, to avoid a Stuck DB for no free space into the transaction log or in the last case, pause the replica and start it after upgrade.

Regards.

former_member185257
Participant
0 Kudos

Thanks Bartosz Jarkowski for your update.

What about HANA system? (If we perform HANA System Patching using SPAM and DR side log shipping is enabled)

Regards.