April 12, 2013 at 10:05 pm
hello masters,
My servers are on virtual environment (SQL SEVER 2005), some one rebooted storage server and now I am able to access instance, but not able to see any databases when I fire sp_helpdb, I am getting an error:
Msg 823, Level 24, State 2, Procedure sysfiles, Line 2
The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x00000000134000 in file 'G:\MFE_PROFOS DATA\GroheUPI.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). This error can be caused by many factors; for more information, see SQL Server Books Online.
Is it storage issue ?
In sql server log can see an error :"Faile to open databases explicitly"
Please help me its urgent.
April 16, 2013 at 12:10 pm
Indeed, looks to me like the path 'G:\MFE_PROFOS DATA\GroheUPI.mdf' is not valid... or SQL cannot see it.
Is the G drive visible from SQL?
Try exec xp_fixeddrives
If the disk isn't there... well your database isn't either.
Todd Carrier
MCITP - Database Administrator (SQL 2008)
MCSE: Data Platform (SQL 2012)
April 18, 2013 at 2:53 am
thanks a lot Todd, for your response,
After long troubleshooting we come to know it was storage issue. After our storage rebooted, one of our drive was not showing. We rebooted our server again and it resolved issue.
Thanks,
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply