SQL 2000 database not shrinking despite using DBCC SHRINKDATABASE and DBCC SHRINKFILE
Posted on 2009-07-01
I have a database that is extraordinarily large and have been trying to shrink it to the size it should be with just the data.
name size unallocated
UltBPMtest 12860.50 MB -249.74 MB
reserved data index unused
13400056 KB 1567864 KB 358840 KB 11473352 KB
Therefore, I want to remove the unused 11 GB and just leave the data at 1.5 GM. This should be possible, but it doesn't seem to work. Any ideas?