data base restoring problem

[Former Member]

hi ,i have installed a test server its sid is'CRT'.it is abap+java . my database is mssql2005. i have restored data base of production server.its sid is 'CRP'.restoration finished successfully.but when i started mmc .sap is not started. i want know whether we have to run any scripts.

is it possible to restore if sid are different.

i have strucked here .any one pls give solution...

[Former Member]

Hi,

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

two script are attached to note.

you need to execute the required script.

1. The SID remained the same - use script user_restore.sql

2. The SID changed - use script user_change.sql

regards,

kaushal

[Former Member]

thank you kaushal.we can directly run script or any othe procedure for this.i mean we have to change any other things.

[Former Member]

Hi,

The SAPNote 551915 is itself very self-explanatory. If you follow the note step by step then it wont be a problem.

Only pre-requisite is you need to install the CI so that the OS users DOMAIN\SAPServiceSID and DOMAIN\sidadm is created.

Regards,

Suhas