SQL Server DBCC SHRINKDATABASE Not Recovering Unused Space
Posted on 2008-10-26
Currently have a 263GB SQL Server 2005 DB used in production MS environment. Each month we truncate more than half the tables from the DB and run a SHRINKDATABASE('mydatabase', TRUNCATEONLY) to recover the unused space and use the smaller DB for our Development environment. Normally is shrinks down to about 165GB. This time, however, using the same process, we cannot shrink the DB physical size at all. We receive no errors, but the size remains at 263GB. We have tried running using SHRINKDATABASE('mydatabase',10) and we have tried using SHRINKFILE commands as well with no luck. Any ideas why it won't shrink?