System Copy on SQL Server 2008 R2

[Former Member]

Hi All,

I want to perform a system copy in ECC6.0 EHP4 with Backup/Restore Method.

As we have OS as Windows Server 2008 R2 64 bit,DB as SQL Server 2008 10.50.1702 and

SAP Kernel as 701 patch level as 196.

Kindly suggest me some guides or helpful links for this.It will be a gr8 help.

Many Thanks

Ajitabh

[Former Member]

See the guide Copying SAP Systems Based on SAP NetWeaver 7.0 Support Release 3 / 7.0 Including 1, 2, or 3 - Using Software Provisioning Manager 1.0. Should be straight forward.

[Former Member]

Hi Kaski,

can you please provide me the SMP links for System Copy Guide?

Many Thanks

Ajitabh

[Former Member]

Oh my, you should really learn how to find documents on SAP Service Marketplace.

https://service.sap.com/~sapidb/011000358700001419132012E

[Former Member]

Hi Kaski,

Thanks for your suggestion,I want to know which method is easier for restoration purpose in Sql Server 2008?Is it detach/attach method or is Backup/Restore Method?

If Detach/Attach Method can you please tell me the steps as it is not mentioned in the SMP Guide?

Kindly Suggest.

Many Thanks

Ajitabh

[former_member184473]

Hello Ajitabh,

The Copying an SQL Server database note (151603) I mentioned covers both methods: Detach/Attach and Backup/Restore.

Regards,

Eduardo

[Former Member]

Hi All,

Thanks for your help guys.

Many Thanks

Ajitabh

[Former Member]

Hi All,

As I am using the Backup Copy of Production Server during System Copy,So I want to know

which are the main RFC Connections of Production Server which should be taken care of?

Is there any issue to Restore the Backup of Production Server for System Copy Purpose?

Kindly help me out as soon as possible as I have to start this Activity today itself.

Many Thanks

Ajitabh

[former_member184473]

Hello Ajitabh,

As per Samuli recommendation, follow the SWPM guide for the system copy.

Regards,

Eduardo

[former_member184473]

Hello Ajitabh,

Check note 151603 for further information.

Do not forget the post steps after the restore.

Also, consider to upgrade the database as version 10.50.1702 is old. SQL Server 2008 R2 SP2 is already released and kernel stack (note 19466😞

Download Microsoft® SQL Server® 2008 R2 Service Pack 2 from Official Microsoft Download Center

Regards,

Eduardo Rezende