Database Corruption- an assertion failure is caused by a software bug or data corruption

  • Hello Friends, have sql server 2005 and I'm getting this error message when I write any query or application connects to the Database.

    "A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support."

  • Nassan (1/27/2016)


    Hello Friends, have sql server 2005 and I'm getting this error message when I write any query or application connects to the Database.

    "A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support."

    Did you check the error log or run DBCC CHECKDB as the error message suggests?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • What service pack level are you running? Do you know which database is affected? When was your last known good DBCC CHECKDB on that database?

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

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