tag:blogger.com,1999:blog-4641626908594317364.post6745294005555759068..comments2023-09-10T05:21:00.406-07:00Comments on SQL/NoSQL Public Diary: Error 21.The device is not ready in SQL Server error log file. Vimal Kumar Prajapatihttp://www.blogger.com/profile/05206684432065617770noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-4641626908594317364.post-9415243165621637952018-10-05T00:16:32.264-07:002018-10-05T00:16:32.264-07:00This is very common error of SQL database. One rea...This is very common error of SQL database. One reason of this error is corruption in MDF file. To fix this, restore the database from .BAK file. If backup is not up-to-date then, you can repair the MDF file. As Repair_Allow_Data_Loss option of DBCC CHECKDB command could be the reason of data loss so, in that case, you can try SQL recovery software to repair corrupt MDF file. <br />Read more about the software from here: https://www.stellarinfo.com/sql-database-repair.php<br />Techiehttps://www.blogger.com/profile/07023256140248733923noreply@blogger.comtag:blogger.com,1999:blog-4641626908594317364.post-68103768699642681642017-04-24T05:28:20.104-07:002017-04-24T05:28:20.104-07:00Thanks Jeff and Johnson, It helped me a lot in my ...Thanks Jeff and Johnson, It helped me a lot in my case. Anonymoushttps://www.blogger.com/profile/12270668107583407369noreply@blogger.comtag:blogger.com,1999:blog-4641626908594317364.post-6789067945518961742017-02-24T08:59:54.244-08:002017-02-24T08:59:54.244-08:00Thanks (2) worked for me. I have a temporary datab...Thanks (2) worked for me. I have a temporary database on an external drive that I use for Development and sometimes forget to detach it before I unplug everything.Jeffhttps://www.blogger.com/profile/12132574804779166613noreply@blogger.comtag:blogger.com,1999:blog-4641626908594317364.post-23354609831099957112016-12-13T22:09:02.035-08:002016-12-13T22:09:02.035-08:00Thank You John!!Thank You John!!Vimal Kumar Prajapatihttps://www.blogger.com/profile/05206684432065617770noreply@blogger.comtag:blogger.com,1999:blog-4641626908594317364.post-46050188565980315812016-12-12T02:11:38.986-08:002016-12-12T02:11:38.986-08:00Great Share! I have also found a good article for ...Great Share! I have also found a good article for SQL Server Error 823 http://www.sqlrecoverytool.com/fix-sql-server-fatal-error-823.htmlAnonymoushttps://www.blogger.com/profile/13545408673572926380noreply@blogger.com