SQL Server Performance Forum – Threads Archive
Error 8909My company has been migrating Oracle databases to MS SQL Server for years, but recently I have been seeing problems like this example. DBCC results for ‘tablex’.
Server: Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 695582853, index ID 29944, page ID (1:1022477). The PageId in the page header = (4991:-969211840).
There are 0 rows in 0 pages for object ‘tablex’. The only way I am able to get past this issue is to allow data loss. Does anyone know what causes this issue or a better way of recovering from it?
You don’t happen to run a shrink operation at the same time as a dbreindex? If so, then this cam cause this message, but is benign. Reschedule the shrink or dbreindex operation so that they don’t overlap…