Archives: November 2011
As I did for powershell a day Series Blog April 2011, consolidated the all months blog into one pdf file here. I have done this month as well, I Blog about Troubleshooting sql server issues -Errors , which we get during our day to day activity.
you can download… Read more
Day 30 More Fatal Errors and BUGs
- For sql server 2000 and earlier you may get 5242 and 5243 corruption in the record structure(for sql server 2005 onwards you may get 824).
Msg 5242, Level 22, State 1, Line 1
An inconsistency was detected during an internal operation in database… Read more
Yesterday, we discussed what happen when tempdb data file grown very high, now what if log file of any user database has grown high and occupying most of its space. Please see the great blog post to know about what is log and how log file works here by… Read more
Day 29: Fatal Errors 823, 824, 825, 832, OS error 23
- Error 823: IO error OS cannot read the data
Error: 823, Severity: 24, State: 2.
The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset xxxx in file ‘xxx.mdf’. Additional messages… Read more