Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

not able to access databases Expand / Collapse
Author
Message
Posted Friday, April 12, 2013 10:05 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 12:43 AM
Points: 208, Visits: 563
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.
Post #1442004
Posted Tuesday, April 16, 2013 12:10 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 2:37 PM
Points: 1,348, Visits: 792
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)

Post #1442914
Posted Thursday, April 18, 2013 2:53 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 12:43 AM
Points: 208, Visits: 563
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,
Post #1443686
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse