Copy MS SQL database to a new host server with a different SID (ABAP 700)

[Former Member]

Hi.

I'm going to copy a MS SQL database from a host server to a new server (Homogeneous SAP Systems) but with a different SID (old server - ER1 new server - ER2).

I'm using SAP ECC 6.0 with SAP_ABA & SAP_BASIS with 700 Release and according to note 683447 I cannot use SAP tools for MS SQL Server because it is not for this release:

"You cannot use this SAP tool to copy ABAP systems based on release 7.00 or later."

Is this true? Can any one confirm that I really can't use this tools with ABAP systems on release 700? If yes, can some one tell me what is the best practice ("step by step") for copy a database (Homogeneous copy) to a new server with a new SID.

Regards

Armando Santos

[Former Member · Accepted solution]

Hi,

check 151603 :Copying an SQL Server database (homogeneous system copy)

once you change SID you need to execute script which is attached to following note.

551915 - R/3 won't start after database restore or database copy

regards,

kaushal

[Former Member · Accepted solution]

Hi kaushal,

Thanks for your answer.

Regarding to note 151603, can I replace steps 1 to 7, just by:

a) Make a backup file (thru SQL Server ) of my source database.

b) Restore the file (thru SQL Server) on my destination database.

and after proceed with Step 8 (Follow up procedure - note 551915).

Waiting for your comments.

Regards

Armando santos.

[Former Member · Accepted solution]

*TOP URGENT*

Hi kaushal,

Thanks for your answer.

Regarding to note 151603, can I replace steps 1 to 7, just by:

a) Make a backup file (thru SQL Server ) of my source database.

b) Restore the file (thru SQL Server) on my destination database.

and after proceed with Step 8 (Follow up procedure - note 551915).

Waiting for your comments.

Regards

Armando santos.

[Former Member · Accepted solution]

Hi,

a) Make a backup file (thru SQL Server ) of my source database.

b) Restore the file (thru SQL Server) on my destination database.

-> yes you can, but you want to change SID so best way is.

- stop the source SAP system,

- stop SQL server

- copy data file and log file to target server.

- attach DB as different SID

- increase size of TempDB on target system

now perform follow up activities as of note 551915

regards,

kaushal

[clas_hortien · Accepted solution]

Hi,

you can change the SID even through a restore, so if he want to go for a backup / restore approach, it is as good as the detach / attach approach.

Regards

Clas