Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  shrink continue

Author  Topic  inbs Aged Yak Warrior 860 Posts Posted - 2008-12-17 : 02:27:46 reminder: i shrink the DB(sql 2005) and i see that files get growth instead decrease. GilaMonster, i run sp_spaceused and this results: database_name: Comp database_size: 2766.25 MB unallocated_space: 130.75 MB reserved: 1808640 KB data: 1602688 KB index_size: 187496 KB unused: 18456 KB that it mean,that i cant shrink because it have 18MB to shrink?