SQL Error : Msg 21, Level 20, State 1, Line 1 Warning: Fatal error %d occurred at %S_DATE. Note the error and time, and contact your system administrator

Leave a comment (0) Go to comments

SQL Server Error Message :

"Msg 21, Level 20, State 1, Line 1 Warning: Fatal error %d occurred at %S_DATE. Note the error and time, and contact your system administrator."

What and Why "this Error":

This error occurs when a Microsoft SQL Server finds a problem with a statement issued by the current process. This could be because of many reasons like :

  • File level corruption
  • Statement tried to access a corrupted page
  • Current statement tried to find record on missing or corrupted page/record/file/index
  • Statement tried to access a corrupted table / index

The Root cause of the issue can be found by looking at specific  fatal error number, which was returned initially in error message

Action Required to resolve this Error:

Action Required is 100% dependent on the fatal error number but most of the time, you need to check database consistency to confirm there is no corruption in the database by running statement

DBCC CHECKTABLE and DBCC CHECKDB

If the index is corrupted, rebuild the index

Note:

  1. There could be a probability that you connection is ended immediately after this error message.
  2. Severity level 20 indicates a problem with a statement issued by the current process.
  3. %d, %ld, or %D means Decimal integer value
    %x means Hexadecimal number value
    %ls or %.*ls means Character string value
    %S_type means SQL Server -defined structure value
    %c means Single character value
    %lf means Double floating-point number value

Tag : "Msg 21, Level 20, State 1, Line 1",SQL Server Error Warning: Fatal error occurred at … Note the error and time, and contact your system administrator, SQL Server Msg 21, Level 20, State 1, Line 1 Warning: Fatal error %d occurred at %S_DATE. Note the error and time, and contact your system administrator.


EOF - SQL Error : Msg 21, Level 20, State 1, Line 1 Warning: Fatal error %d occurred at %S_DATE. Note the error and time, and contact your system administrator, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.