Re: dbcc repair_allow_data_loss

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: skrampe (anonymous_at_discussions.microsoft.com)
Date: 05/03/04 

Date: Mon, 3 May 2004 02:01:05 -0700

...
You should assume that
data was lost if you had to use this option and so your business or
application logic may no longer be correct (constraints etc).
....
     
Just to be sure: You mean, that it's possible that data is lost and we do not have any information about this in the Log-File of the repair job?

We check our database every night.
So, what would you suggest if we'll find consistency errors again (with the suggestion repair_allow_data_loss)?

Go back to the last complete backup? (lose 24 h work of the users)!
Have a system downtime and try to repair the database?

Thank you very much for your help!

Regards,

Sven Krampe

Relevant Pages

  • Lost Column in List View
    ... I have an older version of Microsoft Works-I use the ... database for my small business. ... column to move it & I lost it. ...
    (microsoft.public.office.misc)
  • UI - Period.
    ... > non-MV world without changing how the database is organized. ... > for-free libraries like the D3 Class Library and simple wrappers like ... and intuitive collection of 'stuff'. ... remains the power is lost; ...
    (comp.databases.pick)
  • Warning - Manual rebuild of database loses lots of data
    ... I reported that my Entourage database showed symptoms of corruption ... I exported all items from my 2008 database to an Entourage archive (.rge ... Diane has probably not tested her instructions on an IMAP account. ... Entourage preferences were lost and had to be re-entered. ...
    (microsoft.public.mac.office.entourage)
  • Re: What happens when you lose Log files before shutting down EX Srv?
    ... then the database will mount and transactions ... that were in the logs will be lost. ... The reason why the logs exist is to make sure that the database is ALWAYS ... >>what happens if you lose a log disk. ...
    (microsoft.public.exchange.admin)
  • Re: Outsourcing hits home - my home!
    ... Although I'm saddened to hear that Barbara has lost this business, ... dictation I called my contact person but was told that she was not available ... I realized that this account was history. ...
    (sci.med.transcription)