dbTalk Databases Forums  

RE: table error

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss RE: table error in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rand Boyd [MS]
 
Posts: n/a

Default RE: table error - 01-08-2004 , 10:30 AM






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.


Reply With Quote
  #2  
Old   
biju george
 
Posts: n/a

Default RE: table error(corruption) - 01-10-2004 , 10:08 PM









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



Quote:
-----Original Message-----
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.

.


Reply With Quote
  #3  
Old   
biju george
 
Posts: n/a

Default RE: table error - 01-11-2004 , 10:13 PM



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




Quote:
-----Original Message-----
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.

.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.