Homogenous System Copy in Windows 2003 server and Sql server 2005

[former_member196664]

SAP Gurus,

I am going to start a system copy tomorrow from PRD to QAS with windows 2003 server and sql server 2005 with same kernel level. I am trying to find the procedure to perform the copy and found below. Please help and let me know if these are correct. I appreciate your help at the earliest.

1. Pre-copy steps
2. Save copy of target profiles
3. Save copy of app server profiles
4. Export of source system files using sapinst (With DB running and Application shutdown)
5. backup source system
6. restore target using source backup
7. Delete the profiles of CI using sapinst of Target system
8. Install Central Instance of target system - using sapinst and export file in step 4
9. Retrieve original profiles of target CI
10. Uninstall App server using sapinst
11. Install App server using sapinst
12. Retrieve original profiles of target app server
13. Post-copy steps

Thanks,

Kavitha.

[former_member209924 · Accepted solution]

Kavitha,

I don't understand the need for Step 4.  What do you mean systems files?  Also, why Step 8, 10 and 11?

In SQL Server, a homogenous copy is as simple as backing up the database (source) to a flat file and restoring the target database with the backup.

After you do this, then you need to perform all the post refresh activities like changing schema, deleting old batch jobs, spool requests, BDLS etc...

Ravi

[former_member196664 · Accepted solution]

Ravi,

As per your reply, all I need to do is Pre-copy steps, source backup to a flat file, restore target using source backup, changing schema, post refresh steps?

How do I change schema for sql sever 2005? I read in other forums that sapinst based installation is needed to change SID and system users. Pls help.

Thanks,

Kavitha.

[former_member196664 · Accepted solution]

Also, could you please share if you have a document.

[former_member209924 · Accepted solution]

Please take a look at these SAP Notes.

555223 - FAQ: Microsoft SQL Server

193816 - Restore with SQL Server

151603 - Copying an SQL Server database

1294762 - SCHEMA4SAP.VBS

Ravi

[former_member196664 · Accepted solution]

I took the steps from http://joeysbasisblog.blogspot.com/2010/10/sap-system-copy-procedure.html

Is my understanding not correct?

Thanks,

Kavitha.

[former_member209924 · Accepted solution]

Please take a look at this thread.

http://scn.sap.com/message/6926189

Ravi

[former_member196664 · Accepted solution]

Thank you so much. I have redefined based on your reply. Is this correct now. Pls let me know. (So backup/restore is not needed for sapinst export/import method right?)

backup source

Pre-copy steps

EXport of source system

backup target profiles

Import of source into target

copy original profiles of target CI

backup app server profiles

Install App server

copy original profiles of target app server

Post-copy steps

Thanks,

Kavitha.

[former_member209924 · Accepted solution]

Looks good.  Correct, when doing export/import backup/restore is not required.  But, be aware that when you do an export, your system has to be down.

Ravi