Post reply

Database marked as suspect

  • June 17, 2005 at 1:36 pm

    #93213

    When I start my SQL Server 2000 (sp3 windows 2000) one of my databases is marked as suspect. 

    SQL Server Log

    • SQL Server Assertion: File: <p:\sql\ntdbms\storeng\drs\include\record.inl>, line=1447

      Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <= MAXDATAROW'.

    • Location:  p:\sql\ntdbms\storeng\drs\include\record.inl:1447

      Expression:  m_SizeRec > 0 && m_SizeRec <= MAXDATAROW

      SPID:   3

      Process ID:  512

    • Error: 3624, Severity: 20, State: 1.
    • Error: 3314, Severity: 21, State: 3
    • Error while undoing logged operation in database 'MyDatabase'. Error at log record ID (14388:388:4)..
    • Error: 3414, Severity: 21, State: 1
    • Database 'MyDatabase' (database ID 5) could not recover. Contact Technical Support..

    What I must to do?

  • June 17, 2005 at 2:58 pm

    #566565

    i had found this problem many times. Tryed dbcc checkdb an other recovery commands but neither solved the problem. I reccomend creating a new database and do a DTS on every table you can.

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

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