dbcc checkdb fix

Tech-Archive recommends: Fix windows errors by optimizing your registry


I'm not a DBA and this is all very new to me. I looked through some previous
posts, but didn't find what I was looking for, so I'm sorry if I just missed
it.

I just upgraded my SQL 2000 server to 2005. I immediately started getting
errors on my BackupExec logs stating that there were errors running dbcc on
some of the databases. I have it set to do a consistency check prior to
backup doing a physical check. I went into SQL and ran dbcc dbcheck on one
of the databases got, "CHECKDB found 0 allocation errors and 1 consistency
errors in database 'databasename'.

So it looks like it's not a BackupExec error, but an SQL error. I didn't
have any of these show up prior to the SQL upgrade and I doubt that the
upgrade caused them. What should I do to fix the error? I'm guessing 'DBCC
CHECKDB REPAIR_FAST' is my first choice, but I don't know how to do this. Do
I do this with the database online? Is there any way to see what the error
really is? I really don't want to make matters worse.

Thank you,
Andy Siegel
Dover, DE
.

Relevant Pages

  • Re: Checkpoint SPID Blocked
    ... really need to run DBCC CHECKDB on this database. ... I have a nifty problem with SQL 7.0. ... We have a situation where the checkpoint process is hung waiting on a pagiolatch_sh to release for a page that doesn't exist. ... DBCCCheckDB and DBCC Checkalloc didn't turn up any allocation errors. ...
    (microsoft.public.sqlserver.server)
  • Re: Checkpoint SPID Blocked
    ... CheckDB and DBCC Checkalloc didn't turn up any allocation errors. ... really need to run DBCC CHECKDB on this database. ... We have a situation where the checkpoint process is ... > SQL just kept going about its business up until the point where another ...
    (microsoft.public.sqlserver.server)
  • Re: dbcc checkdb fix
    ... Running DBCC UPDATEUSAGE will most probably fix this. ... This is just a one time thing after upping a 2000 database. ... Tibor Karaszi, SQL Server MVP ... Basically, you want to execute DBCC CHECKDB, read the error message, ...
    (microsoft.public.sqlserver.server)
  • Re: Update failure on Sql Server 2008
    ... I do not believe it is at all likely the conversion to SQL 2008 did this. ... I suspect the effort is not worth it since I am almost certain you will find the error is actually in your SQL 2000 database, and if it is, then that will not help you fix your SQL 2008 database. ... This could happen in any data type that has certain bit patterns that are not allowed. ... run DBCC CHECKDB WITH DATA_PURITY WITH DATA_PURITY to check only the dbo.SalesLines table. ...
    (microsoft.public.sqlserver.server)
  • Fixed
    ... I also found this article that gives the proper way to move system dbs in sql 2008: ... The model exists where the master states it exists. ... This is the error log prior to detaching the model database. ...
    (microsoft.public.sqlserver.server)