SQL Server Assertion Error While Starting SQL 2008 Service

Home Forums Tech Database SQL Server Assertion Error While Starting SQL 2008 Service

This topic contains 0 replies, has 1 voice, and was last updated by  dFrank 12 years, 4 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #2314

    dFrank
    Participant

    Here is an error message that I experienced on W2K8 R2 Server (Microsoft Windows [Version 6.1.7601]), on SQL 2008 Server Express (10.50.1600.1).

    I was trying to start SQL Server Instance service (the main service), and here the Even Viewer message that I would get:

    SQL Server Assertion: File: <sosexcept.cpp>, line=2480 Failed
    Assertion = 'FALSE'. This error may be timing-related.
    If the error persists after rerunning the statement,
    use DBCC CHECKDB to check the database for structural integrity,
    or restart the server to ensure in-memory data structures
    are not corrupted.

    Additional details – Event ID 17066

    The solution was to wait for a couple of days, run Windows update and restart a couple of times. This message is now is gone and problem repaired itself.

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.