Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2005
    Posts
    6

    Unanswered: Database corrupted?

    Hi all,

    Had a disk problem here, and all apps connected to our database hung. Nothing was responding, rebooted, and mssqlserver hangs on startup.

    If i move the mdf and ldf files of the database in question to another folder, mssqlserver starts up ok, with the db marked as suspect.

    It would seem the the mdf and ldf are corrupted.

    I am restoring a backup from yesterday, but this will take hours.

    Any suggestions trying to recover it as it sits?

    Thanks in advance for any ideas.

  2. #2
    Join Date
    Sep 2003
    Posts
    2

    Corrupted MDF

    I had the same problem just last week. The only fix was to restore from last good backup and bring the db forward as far as you can with transaction logs.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Odds are near certain that you aren't hung, it is just doing a truly massive recovery operation when the server restarts. The only answer I know is to let it recover, then you can go merrily on your way with your data intact.

    -PatP

  4. #4
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Let it recover, it that complete, and run a dbcc checkdb to verify.

  5. #5
    Join Date
    Jan 2005
    Posts
    6
    Quote Originally Posted by Pat Phelan
    Odds are near certain that you aren't hung, it is just doing a truly massive recovery operation when the server restarts. The only answer I know is to let it recover, then you can go merrily on your way with your data intact.

    -PatP
    The restore completed.....now its time for the post-mortem.

    The problem I was having was that I could not access the database using Query Analyzer, any application software, or Enterprise Manager. Any attempt to connect would result in a time-out, or just hang when trying to connect.

    If the DB is not responding, how can one determine if a recovery operation is in progress?

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I use sp_who. Check for a low numbered (usually 10) spid doing a recovery in the database in question.

    -PatP

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    In answer to your next question "How do I run sp_who when I can't connect through Query Analyzer?", the answer is to try the OSQL command line utility, which sometimes works when all others fail.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Jan 2005
    Posts
    6
    Good anticipation blindman

    Thanks for the suggestions. I will file this information away for future reference.

Posting Permissions

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