Results 1 to 5 of 5

Thread: MDF Corruption

  1. #1
    Join Date
    Dec 2009
    Posts
    1

    Red face Unanswered: MDF Corruption

    Hello everyone,

    While writing to the SQL Server database, I might encounter the below error
    message:
    “Error 823
    I/O error <error> detected during <operation> at offset <offset> in file
    '<file>'”
    This error message may occur every time when I start SQL Server and access
    the MDF file.

    Thanks in advance.

  2. #2
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Do a DBCC CheckDB if DB has started.

  3. #3
    Join Date
    May 2009
    Posts
    2

    Re: MDF Corruption

    Use DBCC CHECKDB command to check any logical errors in the database. It is an in-built command in SQL Server to fix application level errors. Else you have to use SQL Database Recovery software to scan the corrupted database and recover all the inaccessible data from it. I hope your problem will be resolved by using DBCC CHECKBD Command otherwise use Stellar Phoenix SQL Recovery Software.

  4. #4
    Join Date
    Apr 2008
    Location
    Along the shores of Lake Michigan
    Posts
    242
    Before using any third party application, which may or may not work IMO, use the built-in DBCC CheckDB. Run:

    DBCC CheckDB with ALL_ERRORMSGS, NO_INFOMSGS and post the result set back here. Do not run any of the repair options until someone can look at the results and determine the next best course of action. Did you check the event viewer on the server to see if it's throwing up any disk i/o issues? That's usually the main cause of corruption.

  5. #5
    Join Date
    Jan 2010
    Location
    Alaska
    Posts
    3
    Did you get this figured out? Message me if you need any help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •