Home Forums SQL Server 2008 Data Corruption (SS2K8 / SS2K8 R2) DBCC CHECKDB Error? RE: DBCC CHECKDB Error?

  • December 18, 2012 at 6:21 am

    #1569527

    GilaMonster (12/18/2012)

    I recommend restoring from the last good full backup. Since the DB is in simple recovery model, that amount of data loss (since the last full backup) must be acceptable to the business.

    uggh...that's a hard recommendation for me to want to think about.

    i think i'd recommend renaming the current database, and restoring the last full backup as the original.

    at least then you can compare tables database to database and try to identify any data they might want to keep.

    This is more of an accidental issue (poor backup plan, unexpected error) than a knowledgeable decision that the business knows it can sustain a data loss for a whole weeks worth of changes.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!