does dbcc checkdb increase size of data files ?

Does DBCC checkdb increase the size of data files ? I have a 300GB database
thats almost full and wanted to know whether the size would grow when I run
DBCC checkdb ?
Also, does the maintenance plan under integrity - > check database integrity
issue the DBCC checkdb statement underlying that ? Using SQL 2000
It should not increase the size of your data files, although it could
increase the size of tempdb data files.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:eo2NeSELFHA.3340@.TK2MSFTNGP14.phx.gbl...
> Does DBCC checkdb increase the size of data files ? I have a 300GB
> database
> thats almost full and wanted to know whether the size would grow when I
> run
> DBCC checkdb ?
> Also, does the maintenance plan under integrity - > check database
> integrity
> issue the DBCC checkdb statement underlying that ? Using SQL 2000
>
|||Hi,
In addition to Wayne's post, check database integrity in maintenance plan
issues DBCC checkdb command.
Thanks
Yogish

does dbcc checkdb increase size of data files ?

Does DBCC checkdb increase the size of data files ? I have a 300GB database
thats almost full and wanted to know whether the size would grow when I run
DBCC checkdb ?
Also, does the maintenance plan under integrity - > check database integrity
issue the DBCC checkdb statement underlying that ? Using SQL 2000It should not increase the size of your data files, although it could
increase the size of tempdb data files.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:eo2NeSELFHA.3340@.TK2MSFTNGP14.phx.gbl...
> Does DBCC checkdb increase the size of data files ? I have a 300GB
> database
> thats almost full and wanted to know whether the size would grow when I
> run
> DBCC checkdb ?
> Also, does the maintenance plan under integrity - > check database
> integrity
> issue the DBCC checkdb statement underlying that ? Using SQL 2000
>|||Hi,
In addition to Wayne's post, check database integrity in maintenance plan
issues DBCC checkdb command.
Thanks
Yogish

does dbcc checkdb increase size of data files ?

Does DBCC checkdb increase the size of data files ? I have a 300GB database
thats almost full and wanted to know whether the size would grow when I run
DBCC checkdb ?
Also, does the maintenance plan under integrity - > check database integrity
issue the DBCC checkdb statement underlying that ? Using SQL 2000It should not increase the size of your data files, although it could
increase the size of tempdb data files.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:eo2NeSELFHA.3340@.TK2MSFTNGP14.phx.gbl...
> Does DBCC checkdb increase the size of data files ? I have a 300GB
> database
> thats almost full and wanted to know whether the size would grow when I
> run
> DBCC checkdb ?
> Also, does the maintenance plan under integrity - > check database
> integrity
> issue the DBCC checkdb statement underlying that ? Using SQL 2000
>|||Hi,
In addition to Wayne's post, check database integrity in maintenance plan
issues DBCC checkdb command.
--
Thanks
Yogish

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.
>