Friday, March 9, 2012

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

No comments:

Post a Comment