Sunday, February 19, 2012

dbcc checkdb not needed?

"With SQL Server 2000, you're no longer required to run DBCC CHECKDB or DBCC
CHECKALLOC statements. The latest version of SQL Server automatically detect
s
damaged pages and fixes them. Ninety-nine percent of database corruption wit
h
SQL Server 2000 happens due to hardware failures."
I read that on http://www.informit.com/articles/pr...dly.asp?p=27784
and
I'm looking for confirmation if it's true or not?
I've searched in BOI for confirmation without success.
Thanks in advance,
Craig.That's not quite true. If you have torn pgedetection turned on (the
default) it can detect torn pages. But there are things DBCC CHECKDB can
detect other than that and should be run on a regular basis for reassurance.
You don't need to run CheckAlloc as it is already included in checkdb but
you should run CheckCatalog.
Andrew J. Kelly SQL MVP
"Craig" <spam@.[at]thehurley.[dot]com> wrote in message
news:ecTMYtxAEHA.2480@.TK2MSFTNGP11.phx.gbl...
> "With SQL Server 2000, you're no longer required to run DBCC CHECKDB or
DBCC
> CHECKALLOC statements. The latest version of SQL Server automatically
detects
> damaged pages and fixes them. Ninety-nine percent of database corruption
with
> SQL Server 2000 happens due to hardware failures."
> I read that on
http://www.informit.com/articles/pr...dly.asp?p=27784 and
> I'm looking for confirmation if it's true or not?
> I've searched in BOI for confirmation without success.
> Thanks in advance,
> Craig.

No comments:

Post a Comment