Shrink database

[mkal]

I have a database that shows
DataFile Size: 30880MB
UsedSpace: 18248MB
FreeSpace: 12632

Logfile size is only 11MB and not a concern.

My question is why I can't shrink the database to a size any smaller that the DataFile Size: 30880MB.

I've run the dbcc shrinkfile command w/truncate only and nothing changes. Also tried dbcc shrinkdatabase with out any change in size. Why can I not shrink the database to say a size of 20000MB?

Thanks,
Mike

 

[mrdenny]

Can you post a screenshot of the output of the DBCC SHRINKFILE command? Please post the output of both the Results tab and the messages tab.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[mkal]

My bad on the dbcc shrinkdatabase command. I wasn't telling it to release the space back to the OS. All is well, this post can be closed.

Mike