SQL Server 2000 - Consistency Errors

  • We are getting the following consistency error now and then when we run "dbcc checkdb" command.

    17066 :

    SQL Server Assertion: File: <recbase.cpp>, line=1378

    Failed Assertion = 'm_offBeginVar < m_SizeRec'.

    1. Why consistency errors occur in database? What are the possible reasons behind them?

    2. Can anyone let us know how to fix this problem?

    Thanks in Advance.

    - Vasu

  • Most DBCC errors are due to data corruption and the reasons for corruption can be many.  If it were me, I definitely be checking my server system and application logs for any messages and also checking the drives to make sure that they're operating normally.  There is an article from microsoft about assertion messages here that may help you:

    http://support.microsoft.com/kb/828337

    If your data is of a critical nature you may have to contact product support to assist you with this problem.  Best of luck and please let us know how it goes. 

    My hovercraft is full of eels.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply