Could DBCC REINDEX be the cause? The mdf size has been increasing by 1 -
1.5 GB everyday since we started re-indexing. We do this on a daily
basis.

Thanks
Gaurav

-----Original Message-----
From: Vanessa van Gelder
[mailto:mssqldba-ezmlmshield-x47506058.[Email address protected]
Sent: Tuesday, July 31, 2007 2:36 PM
To: LazyDBA Discussion
Subject: RE: Unused space in DB

Well what is happening for it to be created like that.. ?

Vanessa Fredanus- van Gelder| SQL DBA | DXS Systems | Tel. +27 21 853
3317|
Fax. +27 21 854 7953

You must be the change you want to see in the world. Mahatma Gandhi





-----Original Message-----
From: Gaurav Kohli
[mailto:mssqldba-ezmlmshield-x20053149.[Email address protected]
Sent: 31 July 2007 07:32
To: LazyDBA Discussion
Subject: Unused space in DB

Hi Experts,

Below is the result of "sp_SpaceUsed" on one of our database in SQL
Server 2000.

Reserved: 35926800 KB
Data: 10906952 KB
Index Size: 2400560 KB
Unused: 22619288 KB

It shows 22GB of unused space. The mdf file size is 36 GB out o which 22
GB is unused.

Is there anyway I can reduce the size of this file so that the mdf file
size gets reduced by 22GB?

I tried DBCC SHRINKFILE, but it reduces the size by only 2GB and after a
few minutes the size gets back to 36 GB.

Pls advise.

Thanks
Gaurav



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---

DXS - The Essential Healthcare Information Solution
http://www.dxs-systems.com/



DISCLAIMER:

This communication (including any attachments) may contain confidential
or proprietary information. If you are not the intended recipient and
you have received this communication in error, you should destroy it
without copying, disclosing or otherwise using its contents and notify
the sender immediately of the error.

Internet communications are not necessarily secure, and may be
monitored, intercepted or changed after they are sent. DXS and its
subsidiaries do not accept liability for any loss you may suffer as a
result of interception, or any liability for such changes.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html







MS Sql Server LazyDBA home page