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.
| Author |
Topic |
|
lols
Posting Yak Master
174 Posts |
 Posted - 2008-08-19 : 22:00:53
|
Hi,My database shows the following statistics.database_name database_size unallocated spacesilverdb 155.20 MB 101.05 MB The recovery model is Simple. Now I have tried numerous times to Right click database > Tasks > Shrink database. However the db does not shrink.What do I do to reclaim this 101 MB space?Thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-19 : 23:35:57
|
| You can't shrink db to size smaller than initial ones. And I'll not fight for 100mb space. |
 |
|
|
|
|
|
Database doesn't shrink