Search

Tuesday, June 21, 2011

How to take backup of data if the system got corrupted?


You may require emergency data backup in following situations
  1. The OS is corrupt or system is not booting
  2. The OS is running but FusionRetail 6 is not starting up
  3. Microsoft SQL Server Management Studio Express is not present.
  4. You do not know how to use SQL Server Management Studio Express to take backup.

Please use the following steps to take emergency backup of data in case of emergency

First we have to stop the SQL Server if that is running. For stopping the SQL use the following step.
    • Go to Start > Run > Type net stop mssql$

    • Copy the data directory of the database. (Usually C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data)
    • Make sure that the data files with extension .MDF and .LDF is present
      ** Once You have copied the above files to another computer or any safe place…
      • After Installing SQL Server, Use "Attach Database" option in Management Studio to attach this MDF file.

      37 comments:

      1. Very Useful Info.............
        the person who goes through this issue, knows it better!

        Regards,
        Swapan Das
        My Blog - Human Placental Extract

        ReplyDelete
      2. Its very helpful for Support

        ReplyDelete
      3. hi sir this is raghu my mdf file is getting error i have the important data in that file how to get the data. i am using that data in my accounting pack.so please kindly give me the solution.

        ReplyDelete
      4. Hi Raghu,

        Check below links, these might be helpful for recovering mdf file.

        http://sqlanddotnetdevelopment.blogspot.com/2010/01/troubleshooting-error-8908-in-damaged.html

        http://sqlanddotnetdevelopment.blogspot.com/2011/03/resolving-internal-error-buffer.html

        http://sqlanddotnetdevelopment.blogspot.com/2010/12/fixing-error-2570-post-mdf-file.html

        http://sqlanddotnetdevelopment.blogspot.com/2011/03/database-corrupt.html

        http://sqlanddotnetdevelopment.blogspot.com/2011/01/how-to-recover-mdf-file-when-you.html

        http://sqlanddotnetdevelopment.blogspot.com/2011/01/how-to-fix-error-7995-in-corrupt-ms-sql.html

        ReplyDelete
      5. i am geting error is:
        error3624:
        location:recbase.cpp:1371
        expression: m_nVars>0
        spid:51
        processid:2376

        ReplyDelete
      6. sir please extract my mdf file data plz
        my sql server is 2000 iam not tecnical person so please extract my .mdf file.give me mail id i will send my mdf file it have in 8mb

        ReplyDelete
      7. My mailID is arun.ladha@yahoo.co.in

        ReplyDelete
      8. sir i will send the mail from maruthia@gmail.com

        ReplyDelete
      9. Hi Raghu,
        The data files cannot be attached. You have to restore the DB from last successfull backup.

        ReplyDelete
      10. i did not have the back up sir.i have only data file

        ReplyDelete
      11. i will send my data file again if u dont mind give me ur mobile no i will cal u and i will expline all the my problem sir please do the faver for me sir

        ReplyDelete
      12. Hi Raghu,
        I am not in India now. Send me data files again.

        ReplyDelete
      13. Hi Rashu,
        You data files are attached normally. I had sent you the backup attached in email.

        ReplyDelete
      14. how to add my sql server to u r sended file

        ReplyDelete
      15. dear sir really thanking you for ur co operation rally thanking you sir

        ReplyDelete
      16. sir iam stadyed at kolkata in chitharanjan avenue

        ReplyDelete
      17. Restore the data normally with option in SSMS

        ReplyDelete
      18. sir thank you very much for your cooperation.really hats-of to you sir.

        ReplyDelete
      19. hi sir how r u?
        when u r coming to india

        ReplyDelete
      20. where r u sir ? ru in kolkatta

        ReplyDelete
      21. sir i am using accounting software it runs front end java data base in sql it is secured or not please give me the suggestion

        ReplyDelete
      22. we will meet shortly in kolkata

        ReplyDelete
      23. sir i am using accounting software it runs front end java data base in sql it is secured or not please give me the suggestion

        ReplyDelete
      24. Your SQL Database is not secured. Check below link for security:
        http://sqlanddotnetdevelopment.blogspot.com/2010/12/how-to-protect-your-microsoft-sql.html

        ReplyDelete
      25. can i talk to u personally if u have no mind sir plz give me u r no i will cal u sir

        ReplyDelete
      26. You can talk to me aver email. My email ID is arun.ladha@yahoo.co.in

        ReplyDelete
      27. hi sir how r u?
        happy holi u & ur family

        ReplyDelete
      28. Hello Raghu,
        I am fine.
        Happy Holi to u and your family

        ReplyDelete
      29. hi sir hoe r u?
        i am good sir .

        ReplyDelete