Skip to Content
avatar image
Former Member

OS u201Cwindowsu201D down sudden

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 31, 2009 at 08:45 AM

    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))

    8) Follow the Post Installation Steps as defined in the System Copy.

    Regards

    Anwer Waseem

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 04, 2010 at 09:06 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded