Hi there

The only issue I can think of is your growth settings for your DB, I bet you
have a % growth?? - I tend to regard this has bad practice, consider locking
yourself into a fixed size for ease of management.

Cheers

Ck

-----Original Message-----
From: Mafhara, Takalani [mailto:[Email Address Removed]
Sent: Friday, 26 March 2004 2:08 PM
To: LazyDBA.com Discussion
Subject: DB ballooned after running DBCC REINDEX

Hi , I had a 7 GB database and I run the rebuild index on the database
and it ballooned to 17 GB .........and the data file is the one that
ballooned not the log . Any help ?



****************************************************************************
*
The information contained in this e-mail is confidential and may
be subject to legal privilege. If you are not the intended recipient,
you must not use, copy, distribute or disclose the e-mail or any
part of its contents or take any action in reliance on it. If you have
received this e-mail in error, please e-mail the sender by replying
to this message. All reasonable precautions have been taken to
ensure no viruses are present in this e-mail and the sender cannot
accept responsibility for loss or damage arising from the use of this
e-mail or attachments.
.***************************************************************************
**


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page