Results 1 to 3 of 3

Thread: SQL I/O Error Help

  1. 03-19-2004, 01:02 PM #1
    westladog
    westladog is offline Registered User
    Join Date
    Mar 2004
    Posts
    1

    SQL I/O Error Help

    The database server crashed, and there was no backup! I made daily backups
    onto the server but a power failure destroyed the entire RAID. The only
    backup I had was 10 days ago so now the QAS is not the production server.
    (They didn't want to buy a backup tape drive)

    A new problem that I have now is that I can't perform a backup. It seems
    that one of the database file is corupted (although the database is
    functioning).

    The error I am getting is:
    Error: 823, Severity: 24, State: 2
    I/O error 121(The semaphore timeout period has expired.) detected during
    read at offset 0x0000041ff40000 in file 'E:\QASDATA2\QASDATA2.ndf'.
    I tried doing an offline but it failed. When it got to the file, it stopped after a while.
    Reply With Quote Reply With Quote
  2. 03-19-2004, 01:19 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Run DBCC CHECKDB to see if there is any corruption.
    Reply With Quote Reply With Quote
  3. 03-19-2004, 01:24 PM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    And check windows event log to see if have any disk and/or controller related errors.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules