March 11, 2012 at 9:31 am
can any body help us to resolve the following problem with sql server 2008 sp2:
The operating system returned error 21( failed to retrieve text fro this error. Reason:15105) to SQL server during a read at offset 0x0000000100e000 in file ' mdf file location' Additional messages in the SQL server error log and system event log may provide more detail. this is a severe system-level error condition that threatens database integrity and must be corrected immediately. complete a full database consistency check (DBCC CHECKDB). this error can be caused by many factors for more info see SQL server books.
EventID: 823
March 11, 2012 at 9:34 am
This is an IO error and will cause integrity errors in your databases. You need to get your SAN team involved to check out the IO subsystem and correct any issues.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 11, 2012 at 9:47 am
run dbcc checkdb on that database and see what all errors are coming?
March 11, 2012 at 10:23 am
Run DBCC CHECKDB(dbname) WITH NO_INFOMSGS and post the output here.
DON'T detach the db. Don't restart the service or server.
March 11, 2012 at 10:38 am
Operating system error 21 means "The device is not ready", so you have a drive that has a SQL data file on it that's disappeared.
You need to resolve the drive problem first, identify why it has disappeared and resolve that. There's no point in running CheckDB until you've done that, will it will tell you is that the file is unavailable.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply