Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: November 2011

Download: Troubleshooting a day – Nov 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

0 comments, 603 reads

Posted in Vinay Thakur on 30 November 2011

Day 30: More Fatal Errors and BUGs

Day 30 More Fatal Errors and BUGs

  1. 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

0 comments, 923 reads

Posted in Vinay Thakur on 30 November 2011

Day 2: Log file grown high cannot shrink log file.(available size in – negative)

Description:-

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

0 comments, 202 reads

Posted in Vinay Thakur on 29 November 2011

Day 29: Fatal Errors 823, 824, 825, 832, OS error 23

Day 29: Fatal Errors 823, 824, 825, 832, OS error 23

  1. 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

1 comments, 1,394 reads

Posted in Vinay Thakur on 29 November 2011

Day 28: Linked server errors

This post was published to Vinay Thakur – Sql Server DBA at 5:05:51 PM 11/25/2011             Day 28: Linked server errors Linked server is another good linking took where you can linked the server access the data from different … Continue reading

Read more

0 comments, 227 reads

Posted in Vinay Thakur on 28 November 2011