DB Consistency errors

• Vishal Singh

  SSCertifiable

  Points: 5830

  More actions

  July 27, 2009 at 11:11 pm

  #133511

  Hi,

  Couple of my production databases reported Consistency error

  (more than 800 errors per databases).

  CHECKALLOC reported 0 errors.

  I repaired them with allow_data_loss as this was the minimum DBCC repair level.

  My DBs are fine now but I want to check when exactly those consistency errors started coming in and then to find out the root cause.

  I am exploring everything so far and so how looking out for similar expertise from you guys. Thanks

  VS

  -Forum Etiquette: How to post Performance Problems[/url]

  -Forum Etiquette: How to post data/code to get the best help [/url]

• Rajesh kasturi

  SSCarpal Tunnel

  Points: 4007

  More actions

  July 27, 2009 at 11:42 pm

  #1030838

  can you post the sample error message....

  Rajesh Kasturi

• Chand00

  SSCertifiable

  Points: 6466

  More actions

  July 27, 2009 at 11:59 pm

  #1030845

  Duplicate post. Please post your replies at http://www.sqlservercentral.com/Forums/Topic760489-146-1.aspx

  [font="Verdana"]Thanks
  Chandra Mohan[/font]

• Vishal Singh

  SSCertifiable

  Points: 5830

  More actions

  July 28, 2009 at 12:02 am

  #1030847

  duplicate post was because of site strange behaviour. Gail can you delete one of it...

  -Forum Etiquette: How to post Performance Problems[/url]

  -Forum Etiquette: How to post data/code to get the best help [/url]

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  July 28, 2009 at 1:09 am

  #1030874

  Vishal Singh (7/28/2009)

  ---

  Gail can you delete one of it...

  I'm not a moderator. Only Steve can delete threads here.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Vishal Singh

  SSCertifiable

  Points: 5830

  More actions

  July 28, 2009 at 3:37 am

  #1030919

  Ohk..I thought you are a moderator...thanx for the info.

  -Forum Etiquette: How to post Performance Problems[/url]

  -Forum Etiquette: How to post data/code to get the best help [/url]