Bulding a new SAP system with backup of source

[Former Member]

Hi Techies,

We are planning to build a new SAP system by making a copy of source system with different SID.

Source and target databases will be MSSQL 2008, and application is BW on windows

On target we have other SAP instance which we will delete before installing the new SID.

What would be the best approach - Homogenous system copy using backup restore (Using SAPInst)?

Or any other alternative?

Thanks in advance.

Regards,

Nick Loy

[markus_doehr2 · Accepted solution]

> What would be the best approach - Homogenous system copy using backup restore (Using SAPInst)?

> Or any other alternative?

If the <SID> of the installed system and the to-be-installed system is different the best and easiest approach is using sapinst; you could do all the steps manually (creating users, assigning permissions to files and registry keys, editiing policies etc.) but that is tedious and error prone. I'd go for sapinst. Restore the database on the target system and run sapinst - system copy.

Markus

[Former Member]

1. take off-line backup of existing system database

Ganesh,

A small correction here, I would change offline to online here.

Any challenges or suggestions?

Regards,

Nick Loy

[ganesh_borase2]

Hi,

Actually, offline backup is easiest way to restore.

depends, you want use off-line or online backup.

At online scenario, I think not much of effect, you have to only restore by using SQL server

at the time of restore you have to input proper parameter like database name.

Thanks

Ganesh

[ganesh_borase2]

Dear Nick,

Try to following steps.

1. take off-line backup of existing system database.

2. fresh installation of SAP.

3. Detach the database from newly installed SAP system.

4. Copy the source database(old SAP installation) to newly installed system.

5. Rename the folder and files accordingly new SID.

6. Run the STM tool.

Thanks

Ganesh

[Former Member]

Markus,

Restore the database on the target system and run sapinst - system copy

So restore - Means into existing SID

Run sapinst - On same system to change SID to new?

Sriram,

Best & easy way to do the system copy by backup/restore method, just a month back we are installed the Sap BI system from Ms Sql 2005 to 2008 R2

In my scenario DB versions will be same and I want to change SID too?

Regards,

Nick Loy

[Former Member]

Dear Nick

Once SQL database engine is installed on the target system.

Open SQL Management studio and create a database schema.

Restore the backup taken from the source system and start the system from SAPInst.

Best of Luck....

Thanks and Regards

Khalid Bin Mohammed Al Abusani

[Sriram2009]

Hi Nick Loy

Best & easy way to do the system copy by backup/restore method, just a month back we are installed the Sap BI system from Ms Sql 2005 to 2008 R2

Regards

Sriram

[former_member189546]

Hello,

Download and check the system copy guides.

ww.service.sap.com\systemcopy

regards,

John Feely