does dbcc checkdb increase size of data files ?

19 Mar 2005 5:29 AM

Hassan

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

19 Mar 2005 2:05 PM

Wayne Snyder

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

Show quote

"Hassan" <fatima***@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
>
>

19 Mar 2005 6:49 PM

Yogish

Hi,

In addition to Wayne's post, check database integrity in maintenance plan
issues DBCC checkdb command.

---------
Thanks
Yogish