Homogeneous System Copy using SAP Tools for MSSQL Server (STM)

Prerequisites

• The SAP Tools for MSSQL Server (STM) is applicable for SAP systems based on kernel 6.40 or lower. For SAP system based on kernel 7.0 or higher, you must perform the system copy with SAPinst. Of course, the database will be Microsoft SQL Server only!

• System copy by using the detach/attach or backup/restore method. (in this example, backup/restore is used)

• Create the full backup of the source system.

• Install the same operating system, database and SAP version as source system.

Restore the source system backup.

• Download the STM from the SAP Service Marketplace (SWPM)

Homogeneous System Copy

1. Launch the STM (sapinst).

System Copy STM - Database Copy Completion

2. Enter the Profile Directory and the Password of <sidadm>. The Windows Domain will auto fill as per your Windows config.

System Copy STM - Profile Directory

3. Enter the MS SQL Server instance name. Make sure that your database is running. The database server connection uses Windows authentication. You can also specify a remote database host. For a default instance, enter . For a named instance, use the format \.

System Copy STM - Database Connection

4. The installer will note that the installation will use the existing database (database that restored earlier). Click Next.

System Copy STM - Database Identification

5. Choose ‘Next’ to start with the values shown. Otherwise, select the parameters to be changed and choose ‘Revise’. You are then taken to the screen where you can change the parameter. You might be guided through other screens that have so far been processed.

System Copy STM - Parameter Summary

6. The execution will start.

7. The system copy is complete.

System Copy STM - Completed

8. Finally, perform the post system copy as in normal homogeneous system copy guide. Then, you are done!

• Rename the database logical from source to target using the SQL Server Management Studio.

• Delete the source data from transaction code ST03N, DB13, ST22, DBO2

• Configure the SM36, STMS, RZ04, DB13.

Reference

SAP Note 683447

You May Also Like

Leave a Reply?