February 16, 2012 at 1:29 am
Hello Guys,
One of our prod servers went offline and I received a Ticket mentioning the below error.
ftwp1lqrbgd01 - SQL EventID 823. The operating system returned error 21. The device is not ready
Can any body help me to interpret this error. The first part(ftwp1lqrbgd01) in the above error is the server name.
So I rebooted the server and then looked in Event Viewer. I did not see any event with EvenID 823.
I just dont understad why my server went offline what caused the above error to come up.
Any Ideas?
February 16, 2012 at 1:46 am
I went into the event log and observed the below error
The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x00000000012000 in file 'E:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\IP_SDMP.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.
can any one explain me whats going on?
February 16, 2012 at 1:51 am
it would seem like you lost the E drive (might of been for a short period of time)
do you use a SAN at all, might be worth asking your SAN guys if there where any errors.
are there any other errors int he event logs for around the time this error happened?
i would strongly recommend running DBCC CHECKDB as the error states if the server is back online to ensure that the database is in a consistant state
February 16, 2012 at 2:16 am
What would DBCC CHECKDB do? Why do I run it?
Can u please explain me?
February 16, 2012 at 2:25 am
Please take a look at DBCC CHECKDB in BOL or MSDN.
It will basically do consistancy checks to ensure that nothing bad happened due to the error.
January 11, 2013 at 10:50 pm
na1774 (2/16/2012)
I went into the event log and observed the below errorThe operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x00000000012000 in file 'E:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\IP_SDMP.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.
can any one explain me whats going on?
January 12, 2013 at 8:24 am
na1774 (2/16/2012)
What would DBCC CHECKDB do? Why do I run it?Can u please explain me?
With the errors that you got, your database may now have consistency errors. You should run checkdb to ensure you do not have consistency errors and that the data is good.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 12, 2013 at 8:41 am
10 month old thread (originally) but if samindapawar is asking about consistency checking you should run this
use yourdb
go
DBCC CHECKDB
WITH ALL_ERRORMSGS, NO_INFOMSGS
---------------------------------------------------------------------
January 12, 2013 at 8:57 am
I didn't even look at the date diffs between the latest comment and the rest of the thread. Just watching the active threads and responded - d'oh
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 12, 2013 at 9:03 am
easily done, I only noticed because the post just duplicated an earlier one.
And its later in the day here.............:-)
---------------------------------------------------------------------
January 12, 2013 at 9:06 am
george sibbald (1/12/2013)
easily done, I only noticed because the post just duplicated an earlier one.And its later in the day here.............:-)
Yeah that's it - I'll cling to that excuse 😉
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply