Home Forums SQL Server 7,2000 Data Corruption Error 845: Time out occurred while waiting for buffer latch type 1 for page (0:-1688993522), database ID 5, object ID 0, index ID 0 RE: Error 845: Time out occurred while waiting for buffer latch type 1 for page (0:-1688993522), database ID 5, object ID 0, index ID 0

  • January 5, 2009 at 11:01 am

    #921308

    Eeep. That does not look good.

    There's no way that I know of to get a negative page number, as the page number is an incremental count of 8k chunks of the data file.

    Can you run a checkDB on that database? If possible, before you restart the service.

    DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

    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