Corrupt Table

[Luke Smith]

Hello,

I have one table in a DB with test data therein. This table is getting corrupted
for not apparent reason. This has now happened 3 times. When I run Dbcc CheckTable
for thereon the following message is returned:

Server: Msg 7965, Level 16, State 2, Line 1
Table corrupt: Could not check object ID 1075586970, index ID 0 due to invalid
allocation (IAM) page(s).
Server: Msg 8968, Level 16, State 1, Line 1
Table Corrupt: IAM page (1:8192) (object ID 1075586970, index ID 0) is out
of the range of this database.
DBCC results for 'SpecificSdcEPairsMadeAvailable'.
There are 0 rows in 0 pages for object 'SpecificSdcEPairsMadeAvailable'.
CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'SpecificSdcEPairsMadeAvailable'
(object ID 1075586970).
repair_allow_data_loss is the minimum repair level for the errors found by
DBCC CHECKTABLE (NCNRI.dbo.SpecificSdcEPairsMadeAvailable ).

Does anyone know what the cause of this problem is and how it can be solved?

What affect will the 'repair_allow_data_loss' parameter have on the rest
of the tables in the database? Will they be affected or not?

All input will be highly appreciated.

Thanks
Luke Smith.

[Doug Buchanan]

Make sure you don't have virus scanners or other file-level utilities
messing with the sql files. Once you eliminate that, start looking at
hardware as an issue and move the data files to a different physical disk if
possible.

The proposed repair solution means some pages may be discarded which could
contain valid data. As to what effect that would have on the overall
database, I couldn't say.

"Luke Smith" <ekul@webmail.co.za> wrote in message
news:3bb046f3$1@news.devx.com...
>
> Hello,
>
> I have one table in a DB with test data therein. This table is getting
corrupted
> for not apparent reason. This has now happened 3 times. When I run Dbcc
CheckTable
> for thereon the following message is returned:
>
> Server: Msg 7965, Level 16, State 2, Line 1
> Table corrupt: Could not check object ID 1075586970, index ID 0 due to
invalid
> allocation (IAM) page(s).
> Server: Msg 8968, Level 16, State 1, Line 1
> Table Corrupt: IAM page (1:8192) (object ID 1075586970, index ID 0) is out
> of the range of this database.
> DBCC results for 'SpecificSdcEPairsMadeAvailable'.
> There are 0 rows in 0 pages for object 'SpecificSdcEPairsMadeAvailable'.
> CHECKTABLE found 0 allocation errors and 2 consistency errors in table
'SpecificSdcEPairsMadeAvailable'
> (object ID 1075586970).
> repair_allow_data_loss is the minimum repair level for the errors found by
> DBCC CHECKTABLE (NCNRI.dbo.SpecificSdcEPairsMadeAvailable ).
>
> Does anyone know what the cause of this problem is and how it can be
solved?
>
> What affect will the 'repair_allow_data_loss' parameter have on the rest
> of the tables in the database? Will they be affected or not?
>
> All input will be highly appreciated.
>
> Thanks
> Luke Smith.