Error the device is not ready 21

Want to boost this question? Add details and clarify the difficulty by editing this post.

Closed 12 months back.

You watching: Error the device is not ready 21


The operating mechanism reverted error 21(The gadget is not ready.) to SQL Server in the time of a check out at offset 0x0000000001c000 in file "E:SQL DatabaseS*****dNewAdvWorks.mdf". More messperiods in the SQL Server error log and also device event log might carry out even more detail. This is a severe system-level error condition that threatens database integrity and have to be corrected immediately. Complete a full database consistency examine (DBCC CHECKDB). This error have the right to be led to by many type of factors; for even more indevelopment, watch SQL Server Books Online.


sql-server sql-server-2005
Share
Improve this question
Follow
asked Jan 18 "10 at 16:37
ManishKumar1980ManishKumar1980
2
Add a comment |

4 Answers 4


Active Oldest Votes
12
What operated for me:

change database collection offline...wait a couple of seconds...

change database collection digital This is much better than refounding SQL Server given that restarting SQL Server takes all databases offline (not simply the database that is inaccessible).


Share
Improve this answer
Follow
edited May 21 "13 at 10:50
*

Ladadadada
24.5k66 gold badges5454 silver badges8888 bronze badges
answered May 21 "13 at 10:27
*

Robert van den BergRobert van den Berg
12111 silver badge33 bronze badges
4
Add a comment |
7
I encountered this exact same error this day. Rebeginning the SQL Server company solved it.

The SQL Server Error log and the Windows Event Log showed the exact same error:

The operating system changed error 21(The tool is not prepared.) to SQL Server during a check out at balance out 0x00000000026000 in file "blah.mdf". Further messperiods in the SQL Server error log and also system event log may provide more information. This is a significant system-level error problem that threa10s database integrity and have to be corrected automatically. Complete a complete database consistency examine (DBCC CHECKDB). This error have the right to be caused by many kind of factors; for even more information, view SQL Server Books Online.

And:

Error: 823, Severity: 24, State: 2

After reading Robert van den Berg"s answer, I would certainly try taking the database offline and then online first if you have other databases that you should keep digital.

See more: Topic: Hp Scan To Network Folder Windows 10 Pc Has Logon Password @ Askwoody


Share
Improve this answer
Follow
edited Aug 4 "14 at 16:53
answered Oct 13 "10 at 21:11
*

Paul WilliamsPaul Williams
32622 silver badges99 bronze badges
2
Add a comment |
3
First check out the logs that were indicated in the error message.

Then attempt reestablishing the server, then run the DBCC CheckDB aobtain.


Share
Improve this answer
Follow
answered Jan 18 "10 at 16:43
*

Paulo SantosPaulo Santos
17366 bronze badges
1
Add a comment |
0
In my situation I had the ability to usage

exec sp_detach_db ;

adhered to by

exec sp_attach_db ,
filename1 = N"U:mdfdbName.mdf" ,
filename2 = N"G:ldfdbName_log.ldf";

for 30 databases under SQL 2017. Even though the "detach" process threw an error, SQL did detach the database.

I used pick db_name(database_id), * from sys.master_documents before I started detaching, so I could manuscript out the affix procedure, provided I had actually 30 databases in this state.

I found the catalyst in my instance. I had actually "extended" two volumes the night before. Disk Management had actually reported it can not extfinish the volume at that time. I had chose to wait for a maintenance window to attempt again, and tbelow were no errors yet.

See more: Download Hp Envy X360 M6 Convertible Drivers, Hp Envy X360 M6

Five hours later a backup began that offered VSS. I am encouraged the combination of a failed "extend volume" and also the VSS snapswarm put the volumes in an unusual state.


Share
Improve this answer
Follow
answered Apr 14 "20 at 15:36
*

John ChertudiJohn Chertudi
4122 bronze badges
Add a comment |
Highly active question
. Earn 10 reputation in order to answer this question. The reputation requirement helps safeguard this question from spam and non-answer activity.
The Overcirculation Blog
Featured on Meta
Linked
0
i am obtaining the following error MSSQL$SQLEXPRESS Application log on my server
Related
3
SQL Server 2005 Rekeep from Back-up Failing
2
SQL Server Error: Failed Assertion = ‘m_iteratorInSafeState’
3
DBCC CHECKDB falls short and quits project, ambiguous error message
3
MSSQL error: consistency-based I/O error - have the right to it be led to by an MSSQL or OS problem?
3
SQL server 2005 connect without transaction log - immediate !
0
SQL server corrupt web page
1
DBCC: The database could not be exclusively locked to perform the operation
2
SQL Server Mirroring - Should Witness server be dedicated to mirroring?
0
SQL Server 2008 - Changing Identity increment of a major key in a table
0
Error while Restoring .mdb and .log file of Sql Server 2005 on Server
Hot Netjob-related Questions even more warm questions
Server Fault
Company
Stack Exreadjust Netjob-related
site design / logo © 2021 Stack Exadjust Inc; user contributions licensed under cc by-sa. rev2021.4.1.38970


Server Fault functions ideal with JavaScript allowed
*

Your privacy

By clicking “Accept all cookies”, you agree Stack Exreadjust have the right to save cookies on your tool and disclose indevelopment in accordance with our Cookie Policy.