August 10, 2012 at 2:46 am
Hi Experts,
Server is throwing error
: The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x000000000f2000 in file 'K:\ABC\MSSQL.11\MSSQL\DATA\master.mdf'. 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).
Please help
TIA
August 10, 2012 at 2:53 am
What is the result of DBCC CHECKDB WITH ALL_ERRORMSGS, NO_INFOMSGS when run in master?
Do you have backups of master which you can restore from?
http://msdn.microsoft.com/en-us/library/ms190679%28v=sql.90%29.aspx
August 10, 2012 at 3:29 am
CHECKDB came clean.
August 10, 2012 at 4:23 am
Any error on SQL Server error log and system event log at that time?
try taking manual backup and post the error ,if any?
Regards
Durai Nagarajan
August 10, 2012 at 6:04 am
No error on SQL error log and found hte same error in windows log.
Master DB backup completed without any error.
August 10, 2012 at 6:20 am
No DBCC checkdb error and no backup error - strange
now i dont have any clue..
Regards
Durai Nagarajan
August 16, 2012 at 1:40 pm
Does this occur when you first start the server or intermittently after running for a while? The problem is likely related to the storage subsystem temporarily being viewed as offline by Windows/SQL Server. Check the drivers for the storage subsystem for updates. Look for any other issues noted in the Windows Event Log related to the storage subsystem or drive letter in question.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply