Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
iamsqldba
Starting Member
1 Post |
 Posted - 2013-03-31 : 21:58:43
|
| hi,I am getting the follwing error when i try to login to the sql server Warning: Fatal error 823 occurred at <datetime stamp>. Note the error and time, and contact your system administrator.(Microsoft SQL Server, Error: 21). In the error log: 2013-03-30 22:49:03.88 spid58 The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x000000001be000 in file 'G:\SqlData\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). This error can be caused by many factors; for more information, see SQL Server Books Online.2013-03-30 22:49:05.38 spid57 Error: 823, Severity: 24, State: 2.2013-03-30 22:49:05.38 spid57 The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x000000001be000 in file 'G:\SqlData\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). This error can be caused by many factors; for more information, see SQL Server Books Online.2013-03-30 22:49:06.28 spid20s Error occurred while attempting to drop worktable with partition ID 423521814315008.2 |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2013-03-31 : 22:44:26
|
| Most possible reasons for the error:1. The linked server database is stopped.2. The linked server database is occupied with other stuff (reindexing, backup).3. The linked server is down (power off).4. The linked server is busy with other stuff (defragmenting).5. A cable to the linked server is dropped (replug all cables).6. A router/switch/hub is faulty or not working.7. Too much data is passed on the network. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-04-01 : 18:49:43
|
No.Most possible causes are:1. Corruption in master.mdf2. I/O errors while accessing the G: drive.The error message shows the appropriate next course of action:Complete a full database consistency check (DBCC CHECKDB)Also check the event logs for correlated errorsEDITAlso prett, if you're going to plagerize other people's posts at least give them credit or a link rather than claiming it as your own.  |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2013-04-17 : 06:42:11
|
quote:
Originally posted by russell
No.Most possible causes are:1. Corruption in master.mdf2. I/O errors while accessing the G: drive.The error message shows the appropriate next course of action:Complete a full database consistency check (DBCC CHECKDB)Also check the event logs for correlated errorsEDITAlso prett, if you're going to plagerize other people's posts at least give them credit or a link rather than claiming it as your own.
Hi Russell,Thanks for the suggestion. But I am not taking any credit. I am only try to solve the users issues. Here is Reference link:http://social.msdn.microsoft.com/Forums/en-US/biztalkgeneral/thread/4193ec51-07dd-41b5-8dd0-8a5e33ea7d0b |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-04-17 : 12:28:07
|
| So you copied what someone else copied, and it is still the wrong answer for this situation. |
|
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2013-04-18 : 00:47:49
|
quote:
Originally posted by russell
So you copied what someone else copied, and it is still the wrong answer for this situation.
Hi Russell,I don't understand what problem you have. You have a problem because I am googling the error or you have a problem because I am answering the questions. And I think, The answer is correct or incorrect, this right only for who ask the question. Till the user don't satisfied with the answer or solve the issue, the answer cannot be correct even it is given by me or by you. And If I am giving the wrong answers then why the users are appreciating my post. |
|
|
|
|
|
|
|
|
getting 823 error when logging in to sql server