my database will not reclaim unused space, i've tried shrinking the db, and nothing, i've tried just files in the group, nothing....any help would be greatly appreciated.i've tried:USE [TestDB]GODBCC SHRINKDATABASE(N'TestDB',truncateonly )GOEXEC dba.dbo.isp_Backup @path = '\\natimarksql4\i$\MSSQL\BACKUP\SQL3\', @dbType = '-testdb', @bkpType = 'Tlog', @retention = 30, @bkpSwType = 'NC', @archiveBit = 1, @copyOnly = 0goUSE [TestDB]GODBCC SHRINKDATABASE(N'TestDB',truncateonly )GOEXEC dba.dbo.isp_Backup @path = '\\natimarksql4\i$\MSSQL\BACKUP\SQL3\', @dbType = '-testdb', @bkpType = 'Tlog', @retention = 30, @bkpSwType = 'NC', @archiveBit = 1, @copyOnly = 0goUSE [TestDB]GODBCC SHRINKDATABASE(N'TestDB',truncateonly )GOEXEC dba.dbo.isp_Backup @path = '\\natimarksql4\i$\MSSQL\BACKUP\SQL3\', @dbType = '-testdb', @bkpType = 'Tlog', @retention = 30, @bkpSwType = 'NC', @archiveBit = 1, @copyOnly = 0goUSE [TestDB]GODBCC SHRINKDATABASE(N'TestDB',truncateonly )GO[code]and[code]EXEC dba.dbo.isp_Backup @path = '\\natimarksql4\i$\MSSQL\BACKUP\SQL3\', @dbType = '-testdb', @bkpType = 'Tlog', @retention = 30, @bkpSwType = 'NC', @archiveBit = 1, @copyOnly = 0goUSE [TestDB]GODBCC SHRINKFILE (N'TestDB_FileGroup01' , 0, TRUNCATEONLY)GOEXEC dba.dbo.isp_Backup @path = '\\natimarksql4\i$\MSSQL\BACKUP\SQL3\', @dbType = '-testdb', @bkpType = 'Tlog', @retention = 30, @bkpSwType = 'NC', @archiveBit = 1, @copyOnly = 0goUSE [TestDB]GODBCC SHRINKFILE (N'TestDB_FileGroup01' , 0, TRUNCATEONLY)GO
and neither claim space. the db has 18 files, 2 logs, and 16 data files. SSMS says i have like 99% free space, yet the files do not decrease in size :(