Home » Blog » Topic » Getting Error 9100 In SQL Server 2005

Getting Error 9100 In SQL Server 2005

Stephen West ~ Modified: July 29th, 2015 ~ ~ 1 Minute Reading

Home › Forums › Getting Error 9100 In SQL Server 2005

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • July 7, 2015 at 12:30 pm #327 Score: 0
    Stephen West
    Moderator
    4 pts

    I am working on SQL Server 2005 and suddenly I got this error message:

    Msg 9100, Level 23, State 1, Line 1
    Possible Index corruption detected. Run DBCC CHECKDB.

    If I run DBCC CHECKDB the loss of data occurs. So please give suggestions to eradicate this error.

    July 11, 2015 at 10:31 am #343 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    In such situation you must restore it from backup

    August 28, 2015 at 6:46 am #529 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    1. Run DBCC CHECKDB, make sure all the tables are having a clustered index (physical order of records)
    2. If you need to restore the database, it may be save to restore just the db, if not many files have changed or any extensions has been upgraded since.
     

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.