SAP System copy - SWPM vs HANA studio

[former_member612721]

Hello Community

I know there are numerous blogs regarding system copy procedures on blogs.sap.com, however I couldn't find any blog or note to describe why would one choose SWPM method over the HANA studio backup/restore method and a detailed comparision between the two methods.

a few blogs I found in this regard, but don't clarify what additional steps are required in case inconsistencies arise:

https://blogs.sap.com/2017/10/09/sap-hana-system-copy-homogeneous-recovery-method-using-hana-studio/

https://blogs.sap.com/2015/12/26/hana-system-copy-using-hana-studio-backuprecovery-without-swpm/

( are blogs verified by SAP and can be considered official documentation from SAP ? )

I feel that the backup restore from HANA studio is more simpler and faster to use than SWPM. So that in a recent system copy from PRD to QAS , I chose the HANA backup restore way of refreshing the QAS database.

My problem is after I already finished all the postactivities related to BDLS, RFC, SMLG, SOST, SCOT .... I ran some database level checks and I can see there are still some references to production system 😞 I ran the below query from

1969700 - SQL Statement Collection for SAP HANA - HANA_Configuration_Overview_2.00.040+.txt

and I can see that the production system still appears under CLIENT APPLICATION LOAD section. Although when I go to Performance - Sessions , the correct SAP system appears under APPLICATION column (the quality system)

Whereas all the HANA databases refreshed using SWPM don't have this inconsistency

From which tables does the statement in HANA_Configuration_Overview_2.00.040+.txt get the data . And how can I resolve this ?

I tried to resolve this by running manually all the ABAP reports and function module from note 1709838 - point 5) , using DDIC in 000, but this did not resolve the inconsistency.

They actually finish almost instantly when I ran them manually - not sure if it worked but I hope I did not create more inconsistencies, because I did not run them just after the restore. I ran them after BDLS, SMLG, RZ10, and all other SAP Standard postrefresh activities. Was it wrong to run the ABAP reports after the SAP post refresh activities. ?

RUTCSADAPT (for table declustering, as of NW 7.40)
RADDBDIF
RUTTTYPSET
UMG_POOL_TABLE
RUTPOADAPT (for table depooling as of NW 7.40)
DBPROC_ACTIVATE_PROXIES (as of NW 7.40 Support Package 1)

These are run automatically when using SWPM method, and it usually takes much longer to complete than the duration when I ran them manually

As long as the HANA studio restore has the option to restore from a different database, I assume the HANA studio backup restore method is also supported by SAP, as HANA Studio is a SAP product. But there is almost no information on SAP documentation as to what steps has to be taken afterwards to clear the inconsistencies at DB level.

Can someone please clarify what additional steps have to be taken when using backup restore in HANA studio to get rid of the DB level inconsistencies ?

Thank you,

George

[rkuehberger]

Hi Lars,

I still have a question regarding the System Copy - SWPM vs. HANA Studio. Are there any SAP notes where it's clarified that the only supported way to copy a SAP System with HANA DB is using the SWPM.

Kind regards.

Rudolf

[lbreddemann]

To your question

"( are blogs verified by SAP and can be considered official documentation from SAP ? )"

the answer is a clear no.

The "verification" of community content is only concerned with the community rules of engagement and not with whether the technical content is accurate, recommended or even supported.

As for the question which system copy method to use, you have already discovered one of the drawbacks of simply performing a backup and restore. Namely, that the database contents will be exactly the same including configuration details that are specific and unique to each system.

The conclusion that the fact that SAP HANA Studio provides a backup and restore feature implies that using this feature for a SAP system copy is not warranted. SAP HANA is a database system and "naturally" includes options to backup and restore databases. A SAP system on the other hand consists of more components than just the database.
So, while using the SAP HANA Studio (which has been deprecated for several years now) may be a technical option, it does not give way to any assumption about what could/should be done with it.