Topic: Interesting error
As if the DB broke. Application refuses to work with basis. In a broad gull of an error of type:
Error: 824, gravity: 24, a state: 2
SQL Server detected a logical consistency-based I/O error: a protection invalid parameter. It occurred during a to read of page (1:529) in database ID 7 at offset 0x00000000422000 in file
Thus checkdb produces:
Msg 8921, Level 16, State 1, Line 1
Check is cancelled. In the course of collection of the facts the error has been found out. Probably, the tempdb database reached a storage limit, or the system table is not coordinated. Check up the previous errors.
But at same probably to make and recovery of a DB, the table open, the data is read. Other DB on the same server works normally, transits regularly. What can it be?
SQL2008r2sp2 express, win2003