I have 2 tables in my database that it is corrupted. When I do DBCC
command, I get the following messages..
Msg 605, Level 21, State 1
Attempt to fetch logical page 80641 in database 'niebase_database'
belongs to object 'ap_item_detail', not to object 'inv_tran'.
DBCC execution completed. If DBCC printed error messages, see your
Msg 2506, Level 16, State 3
Table Corrupt: The values in adjust table should be in ascending order
starting from the end of the table (page#=492949 row#=0); check adjust
table in this row
Msg 2524, Level 16, State 1
Table Corrupt: Row length is inconsistent between the computed row
length and the recorded row length on page; check the following page and
row: pageno=492949 row#=0 computed row length=812 row length on page=811
Msg 2596, Level 16, State 1
Page pointer = 0x4ec5800, pageno = 492949, status = 0x101, objectid =
1621580815, indexid = 0 has an incorrect pgfreeoff value of 1926. The
offset should be 843.
The total number of data pages in this table is 1241.
Any recommendation so I can correct these two tables
or do I need to restore from tape backup? however my backup is old...