OS u201Cwindowsu201D down sudden

[Former Member]

Dear Colleagues,

System details: ECC6, Windows 2003, My SQL database

The problem is the OS u201Cwindowsu201D down sudden, Unfortunately the customer didnu2019t have a backup, but the data has been restored such as u201C u201CSIDu201DDATA1, u201CSIDu201DDATA2,u201DSIDu201DDATA3, u201CSIDu201DLOG1 and USR folderu201D

I have tried to implement follows:

Install new System with same old System parameters

Apply SAP Note u201CNote 683447 - SAP Tools for MS SQL Serveru201D----Database copy but it doesnu2019t complete as I should replace the old "SID"DATA* with the new "SIDD"ATA* as mentioned in note guide and while I did this restored the error is occurred u201Ccanu2019t connect to the database.

Furthermore, through SAP Noteu201D Note 1099664 - Changing default restore location for SQLu201D I added the SQL Data File but nothing is effected in the SAP System,

Moreover I canu2019t do windows repair or recovery process,

Please advice with the right action.

Regards,

Ahmed

[ken_halvorsen2]

Hi Ahmed

You've left out quite a bit of information. For example, I'm not sure what you meant by "OS windows down sudden". Did the system crash or just shut down?

What are the error messages when you tried bringing the Original system back up?

Did you try starting all of the services (SQL and SAP)?

The client didn't have a Backup of their Production system before the system went down? That's Not a Good practise. Is this a brand New implementation? Have they "Gone Live" yet?

What did you do to restore to the new system? Copy the datafiles over? Rename the datafiles? Does it have the same <sid> ?

Did you try to Attach the datafiles with the SQL database tools?

Please let us know a little more and we maight be able to help better.

[Former Member]

Dear Ahmed

Please follow the SAP Note 151603 - Copying an SQL Server database

Please find steps below to prepare the new PRD system which is down.

1)Prepare the Migration CD on source system by running the sapinst.

Which you donu2019t have you can prepare by the QAS system then go to the migration folder and replace the parameter u201Csrc.ci.host=prdu201D in the SOURCE.PROPERTIES file.

2)Detach and copy the PRD source DB into the target (QAS) OR restore the PRD DB into the target system (No downtime required)

You already copied and restored the DB from the affected system to the new system.

3)Attach the PRD DB and bring online the system if you detach it.

No action required!

4)Uninstall SAP and drop the database on the new system; if exist!

5)Rename the folder and files by the QASData1 on target system what you copied from the PRD.

You can use the same folder and file which you are using on the PRD system.

6)Attach the DB again on target system which you renamed recently.

Install the SQL server and attach the PRD database

7)Run the sapinst and select the System Copy->MS SQL Server->Target System->Central System-> Based on AS ABAP and AS Java---->Central System Installation ((do select stack according to your system))

😎 Follow the Post Installation Steps as defined in the System Copy.

Regards

Anwer Waseem