DATA consitency errors

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  April 22, 2013 at 12:49 am

  #276706

  I dont have the backup when we ran the dbcc check db got the data consistency errors , how can we bring back the database with out data loss ?

• paul.knibbs

  SSCoach

  Points: 15320

  More actions

  April 23, 2013 at 4:34 am

  #1608993

  Depends what CHECKDB is telling you. If it's saying that the minimum requirement to fix the problems is REPAIR_ALLOW_DATA_LOSS then, with no backups, you can't (or are very unlikely, at any rate) to get that database repaired without losing some data--which is why you should have been backing it up in the first place, of course.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  April 23, 2013 at 4:39 am

  #1608995

  Run the following, post the full, complete and unedited output.

  DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

  No clean backups at all? Someone's not doing their job properly.

  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