January 29, 2004 at 8:57 am
I get this following error when doing an integrity check on one of my databases.
[Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is pointed to by the previous pointer of IAM page (3:3695) object ID 661577395 index ID 0 but was not detected in the scan.
[Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is pointed to by the previous pointer of IAM page (3:16835) object ID 1317579732 index ID 0 but was not detected in the scan.
[Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is pointed to by the previous pointer of IAM page (4:14) object ID 1413580074 index ID 8 but was not detected in the scan.
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 2 allocation errors and 0 consistency errors in table '(Object ID 1461580245)' (object ID 1461580245).
I tried doing the following.
- ran a dbcc chkdb with REPAIR_REBUILD option and reran chk integrity.
dopped teh tables which showed up this error. recreated them and loaded the data and recreated indexes too. reran the same check again. unfortunately same error shows up.
Does anyoen have a different solution to this. any help will be greatly apprecaited.
TIA
January 29, 2004 at 1:54 pm
Call PSS if this is important. It indicates a structural error in the db. If drop and recreate of the tables (and all indexes) did not work, you need PSS.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply