My database went into suspected mode

  • My database went into suspected mode. and after we had run some script, it came out from the suspected mode. but we encountered this error while opening table in database.

    2009-11-02 15:46:42.90 spid51 Error: 824, Severity: 24, State: 2.

    2009-11-02 15:46:42.90 spid51 SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:43686; actual 0:0). It occurred during a read of page (1:43686) in database ID 23 at offset 0x0000001554c000 in file 'H:\MSSQL.SQL2008\MSSQL\DATA\my_db.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

    What is the reason?

    How can I rectify this Problem?

  • Please don't cross post. It just wastes people's time and fragments replies.

    No replies to this thread please. Replies to http://www.sqlservercentral.com/Forums/Topic1676526-3411-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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