I would run DBCC checktable to see if there are any corruption related
errors on this table.

Rand
This posting is provided "as is" with no warranties and confers no rights.

Hi guys ,

1)i runn dbcc checkdb and got result as follows

found 0 allocation errors and 9 consistency errors across
3 tables.

2)when i issue dbcc checktable for table having problem
got following results

object id 336720252, index id 0;page(1:289454) could not
be proceed see other errors for details

table error: object id 336720252,index id 0,page
(1:289454),row58.test(columnoffsets<=(nextrec-prec)
failed.values are 60 and 13.

check table found 0 allocation errors and 2 consistency
errors in table

repair _allow_data_loss is the minimum repair level for
errors found

3)if i run dbcc checktable with repair _allow_data_loss
what will happen will it remove rows having problem only.

pls advice me what step i should take immeadiately

thanks

Biju

Hi Guys,

by doing dbcc check table with repair_allow_data_loss able
to solve the problem even though i lose 82 rows from the
affected table.

after athat i run dbcc checkdb did'nt reported any problem.

can i assume that every thing is ok now?

btw from the windows event log i could'nt find any
hardware related problems.

how i can avoid this types of problems in future?

my sql server is running on aactive/paasive cluster with
transactional replication for reporting server.

can you advice me the steps to be taken for this types of
disaster to avoid any such problems as it is very mission
critical.

thanks

Biju