SQL Server Database Error

  • I get the following error with of of my client's databases:

    SQL Server Assertion: File: (&m_hRowCurrent)'

    After running DBCC CHECKDB command I get this error:

    Msg 8930, Level 16, State 1, Line 1

    Database error: Database 16 has inconsistent metadata. This error cannot be repaired and prevents further DBCC processing. Please restore from a backup.

    Msg 8921, Level 16, State 1, Line 1

    Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.

    Does anyone have any clues how to fix this at all? I appreciate any answers you may have for me.

    Thanks,

  • When exactly does this error appear, on connection to the database or when you are running a query or SP????

  • Were you ever able to sort out this issue i now have the same problem?

  • If you find that your database is corrupted and you need to get data out of the .mdf file (and don't have a good backup), you might find MSSQLRecovery handy.

    http://www.officerecovery.com/mssql/index.htm

    I recently used it on a clients corrupted database and got back most of the data.

    Good luck.

    G. Milner

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

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