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


MS Sql Server LazyDBA home page