Web Analytics Made Easy -
StatCounter Corrupted Mdf File In Sql 2000 - CodingForum

Announcement

Collapse
No announcement yet.

Corrupted Mdf File In Sql 2000

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Corrupted Mdf File In Sql 2000

    hello: i was given a corrupted mdf file, the server the database (sql 2000) crashed and the only file recovered was this .mdf file. I have tried as many of the options that i can find, and still cannot get this database recovered. downloaded several of the programs that claim to be able to recover mdf files and none work.. This latest gives me the following errorQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0xaaaaaaaa; actual signature: 0xd8b4c0f2). It occurred during a read of page (0:0) in database ID 0 at offset 0000000000000000 in file 'C:\DBIO\testy.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

    I created a new database (sql 2008 r2) since I do not have sql 2000 anywhere. renamed the mdf file and then renamed the corrupted one to the new name and restarted. This then brings up the db in recovery_pending mode and I cannot get it out of that mode. Tried setting it to emergency mode, no luck. Is there anyway for me to recover this db?

    No there were no backups of this database at all, and yes, i completely agree that a backup strategy is needed, but i'm just the lucky recipient of the issue

  • #2
    If you have the database at a point where it's barking about running DBCC CHECKDB, have you given that a shot? Let DBCC put the pieces together if it can. If it can't, well, you may be out of luck.
    If the database was on a server that is [several versions] out of mainstream support (did I get that math right? 2000, 2005, 2008, 2008 R2, 2012) I'd consider this recovery exercise to be directly related to the decision not to upgrade [12-year-old] software. I'd report the database to be irreparable and irrecoverable since you have no backup. This jab is .:[NOT]:. directed at you, but at the decision-makers that allow this situation to happen. There. I'm done ranting now. My apologies to all the gentle readers of This stuff just fires me up. I wish you the best of luck.
    Regarding the "recovery software" I'd avoid getting my hopes up.
    That will solve your corruption issue surely because it helped me to come out of some corruption situations. You can get more information
    How to view corrupted mdf file? What do I do it? - TechRepublic

    Comment


    • #3
      I read a similar article and found the problem here:
      https://groups.google.com/forum/?hl=...nd/emytbwleY-A

      Comment


      • #4
        A perfect solution for repair damaged SQL Server database, I would like to refer more reliable perfect software, you can use Kernel for SQL Database Recovery Tool. This software easy to recover crash, OS malfunction, unexpected system shutdown, virus attacks and etc. It can Supports SQL Server versions 2000, 2005, 2008, 2008 R2 and 2012. You can also download free trial demo version - http://www.server.sqldatabaserecovery.org
        Last edited by VIPStephan; Aug 13, 2015, 10:29 AM. Reason: removed link

        Comment


        • #5
          You can try this advanced MS SQL Server Database recovery software, this software some simple steps to recover your corrupted SQl server database file easily. Visit :

          Steps to MDF file recovery -
          1. Select the corrupt MDF file from disk and SQL Server version then click Recover
          2. Preview the recover file and salect the folder to Save
          3. Salect the required saving mode and fill the necessary detail and click OK

          Get more information you can read this blog: http://repairandmanage.blogspot.in/2014/06/sql-server-recovery.html"

          Regards

          Comment


          • #6
            Specially designed for such purposes like to fix severely corrupted database files (MDF) of SQL Server. It thoroughly scans damaged MDF file within a click and displays all the recovered tables including objects such as views, triggers, etc. Download now- mannatsoftware(DOT)com/stellar-phoenix-sql-server-recovery

            Comment

            Working...
            X