Re: Corrupt backup - "An internal consistency error occurred", code 42000

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Kris Shier (ks4hire_at__NOSPAM_yahoo.com)
Date: 05/14/04 

Date: Fri, 14 May 2004 15:25:58 -0400

Thanks for the info!

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:q7i5a05g0objjrt77root0kjk4583no15h@4ax.com...
> Are you running DBCC CHECKDB on a regular basis before your
> backups?

Uh... now I am! :D

 Yesterday, DBCC CHECKDB reported no errors on the 'base, though, and then I
got the same error again when trying to restore it on the production server.
I was able to successfully mount the database by manually attaching the mdf
file, though. ('Plan B')

I spent most of the day working with it, doing import and export operations.
At the end of the day, I deleted all the temp data, ran DBCC CHECKDB (which
showed no errors), and did a backup. I was able to successfully restore
this backup onto my dev server. We'll see Monday if the reverse holds true.

I suspect something about the data I was importing was somehow 'invalid',
but I really have no idea what. I would expect that DTS operations would
throw an error up-front if you are trying to load some kind of data that
could potentially corrupt the database.

Anyone, any comments on this?

Thanks!

Relevant Pages

  • Re: Database recovery with data file only
    ... Although DBCC CHECKDB can detect physical corruption, ... > up the database ken can execute a DBCC CHECKDB and confirm that database ... >> A preferable method is to restore from backup. ...
    (microsoft.public.sqlserver.server)
  • DBCC CHECKDB results - repairable?
    ... earliest one we had) as the database has not gone into production use yet. ... The errors on the backup are as follows (I have snipped out the information ... CHECKDB found 0 allocation errors and 2 consistency errors in table 'ORDERS' ... DBCC CHECKDB. ...
    (microsoft.public.sqlserver.server)
  • Re: Fragmentation Issues
    ... My backup schedule is a full each night in the early morning. ... if I do a full backup and then trucate the tran log I have all I need to ... Do you recommend never shrinking the DB -or- when would you recommend ...
    (microsoft.public.sqlserver.server)
  • Re: DBCC CHECKDB results - repairable?
    ... > I ran DBCC CHECKDB on a database with some performance issues today and received several errors. ... > I restored from a backup as the database has not gone ... > repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB ...
    (microsoft.public.sqlserver.server)
  • RE: dbcc checkcatalog
    ... What does DBCC CHECKDB find? ... It may report more problems. ... Make sue you have a good recent backup ...
    (microsoft.public.sqlserver.server)