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.
      Posted by at
      Labels: ,

      37 comments:

      1. SDJune 21, 2011 at 3:20 PM

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

        Regards,
        Swapan Das
        My Blog - Human Placental Extract

        ReplyDelete
      2. UnknownJune 21, 2011 at 4:50 PM

        Thanks Swapan Da

        ReplyDelete
      3. RamJune 21, 2011 at 6:26 PM

        Its very helpful for Support

        ReplyDelete
      4. raghuNovember 17, 2011 at 5:58 PM

        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
      5. UnknownNovember 18, 2011 at 9:26 AM

        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
      6. raghuNovember 21, 2011 at 1:32 PM

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

        ReplyDelete
      7. raghuNovember 21, 2011 at 1:34 PM

        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
      8. UnknownNovember 22, 2011 at 12:18 PM

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

        ReplyDelete
      9. raghuNovember 22, 2011 at 2:57 PM

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

        ReplyDelete
      10. UnknownNovember 23, 2011 at 10:27 AM

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

        ReplyDelete
      11. raghuNovember 23, 2011 at 6:21 PM

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

        ReplyDelete
      12. raghuNovember 23, 2011 at 6:23 PM

        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
      13. UnknownNovember 24, 2011 at 9:58 AM

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

        ReplyDelete
      14. UnknownNovember 24, 2011 at 10:37 AM

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

        ReplyDelete
      15. raghuNovember 24, 2011 at 2:36 PM

        how to add my sql server to u r sended file

        ReplyDelete
      16. raghuNovember 24, 2011 at 4:56 PM

        dear sir really thanking you for ur co operation rally thanking you sir

        ReplyDelete
      17. raghuNovember 24, 2011 at 5:00 PM

        sir iam stadyed at kolkata in chitharanjan avenue

        ReplyDelete
      18. UnknownNovember 24, 2011 at 5:18 PM

        Restore the data normally with option in SSMS

        ReplyDelete
      19. UnknownNovember 24, 2011 at 5:19 PM

        I am in Kestopur, VIP, Kolkata

        ReplyDelete
      20. raghuNovember 25, 2011 at 3:09 PM

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

        ReplyDelete
      21. annaraghuDecember 2, 2011 at 12:17 PM

        hi sir how r u?
        when u r coming to india

        ReplyDelete
      22. UnknownDecember 8, 2011 at 12:10 PM

        Hi Raghu
        I am back

        ReplyDelete
      23. raghuDecember 9, 2011 at 3:32 PM

        where r u sir ? ru in kolkatta

        ReplyDelete
      24. UnknownDecember 10, 2011 at 3:50 PM

        I am in Kestopur, Kolkata

        ReplyDelete
      25. raghuDecember 14, 2011 at 6:16 PM

        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
      26. raghuDecember 14, 2011 at 6:17 PM

        we will meet shortly in kolkata

        ReplyDelete
      27. raghuDecember 19, 2011 at 1:10 PM

        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
      28. UnknownDecember 19, 2011 at 3:27 PM

        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
      29. raghuDecember 23, 2011 at 11:07 AM

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

        ReplyDelete
      30. UnknownJanuary 3, 2012 at 10:00 AM

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

        ReplyDelete
      31. raghuMarch 7, 2012 at 6:15 PM

        hi sir how r u?
        happy holi u & ur family

        ReplyDelete
      32. UnknownMarch 9, 2012 at 10:04 AM

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

        ReplyDelete
      33. raghuMay 8, 2012 at 5:36 PM

        fine sir

        ReplyDelete
      34. raghuJuly 9, 2012 at 12:07 PM

        hi sir hoe r u?
        i am good sir .

        ReplyDelete

      Subscribe to: Post Comments (Atom)