-
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.
-
Run DBCC CHECKDB to see if there is any corruption.
-
And check windows event log to see if have any disk and/or controller related errors.
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
|
|