Friday, March 9, 2012

Does DBCC CHECKDB include DBCC CHECKCATALOG?

Hi, all.
I want to know if DBCC CHECKDB include DBCC CHECKCATALOG in SQL Server 6.5
and 2000.
Thanks.Nope, it doesn't.
It is extremely unlikely that you do run into CHECKCATALOG problems, but it is not included in the
CHECKDB check (which is why we added an option for CHECKCATALOG in our Db Maint sw...).
In 6.5, you might also want to run NEWALLOC and TEXT_ALL (which are included in CHECKDB for 7.0 and
2000).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Kim Keuk Tae" <zyuuzika@.korea.com> wrote in message news:ebD33l7ZDHA.2308@.TK2MSFTNGP12.phx.gbl...
> Hi, all.
> I want to know if DBCC CHECKDB include DBCC CHECKCATALOG in SQL Server 6.5
> and 2000.
> Thanks.
>

No comments:

Post a Comment