Results 1 to 10 of 10
  1. #1
    Join Date
    Sep 2011
    Posts
    1

    Unanswered: How to recover SQL Server which is corrupt?

    hi,

    I am facing corruption situation in SQL Server 2005. Can anyone provide me perfect solution for performing recovery mechanism of MDF files?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Yes.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Well, I don't know if just anyone can provide it. I readily admit that there are some people who can provide it.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by MCrowley View Post
    Well, I don't know if just anyone can provide it. I readily admit that there are some people who can provide it.
    Very true, but I stand by my original answer. Given sufficient knowledge of the database and the corruption, there is at least one person that could provide the perfect solution. Finding that person might be a trick, but given the details on the database and the corruption I'm pretty sure that even I could find the person that could give the perfect answer.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  5. #5
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    dumb question maybe: how about restore from backup?

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    jezemine! It is good to see you here at DBForums again!

    Backups! What a thought!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  7. #7
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    It could be just a non-clustered index that is corrupt. If so, he would not have to lose a couple days of work, and just rebuild that index. A little hard to say from the information given, though.

  8. #8
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    Quote Originally Posted by Pat Phelan View Post
    jezemine! It is good to see you here at DBForums again!
    let's cut off blindman before he's got a chance:

    I was gone?

  9. #9
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by jezemine View Post
    let's cut off blindman before he's got a chance:
    That's usually r937's line.

    Quote Originally Posted by jezemine View Post
    I was gone?
    Oh, but that lends a whole new zen twist to the line! I like it!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  10. #10
    Join Date
    Jun 2011
    Posts
    31
    Provided Answers: 1

    Thumbs up Recover & Repair corrupt SQL server

    Hello Smith,

    You can handle corruption in sql server database by two methods, first one is in-build command and another is third party mdf recovery utility. Have you maintain the backup of corrupted mdf file? If don't have any backup then it is suggest to run DBCC CHECKDB without any repair clause first, the command will offer you a suitable repair clause and run again with repair clause. If you will still have a problem then try an updated mdf recovery utility. MDF Recovery utility repairs corrupt mdf file and compatible with SQL server 2005.

Tags for this Thread

Posting Permissions

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