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 |
|
Joozh
Posting Yak Master
145 Posts |
 Posted - 2006-01-31 : 00:48:33
|
| Hi,the size of one of my database has grown considerably in just a short time period. I have tried to shribk the database but the size remains the same.Then I recalled reading a post somewhere and thus checked the 'Recovery Model' property of the database but that too appears to be correct (i.e. not consuming too much space for the log file). The 'Recovery Model' property is set to SIMPLE.Can anyone kindly guide as to how I can go about shrinking the size of my database.Thanks & Regards.-J |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-31 : 01:29:11
|
| Is there a chance that your database is actually full of data, and has no "slack" space?What doesEXEC sp_spaceusedsay?Kristen |
 |
|
|
Joozh
Posting Yak Master
145 Posts |
Posted - 2006-01-31 : 01:46:01
|
| Hi Kristen,I hope I have done this correctly??? I ran the command "EXEC sp_spaceused" in Query Analyzer (after selecting the relevant database) and got the following results:database_name| database_size| unallocated spaceMyDatabase | 1414.19 MB | 97.00 MBany clues?Thanks & Regards.-J |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-31 : 02:37:39
|
| I don't reckon you can squeeze it any more. You have 97MB unused in 1.4GB of database - and probably that's just "elbow room" which can't be squeezed out.How much space does Enterprise Manager say it can remove? (Right click Database : All tasks : Shrink - what's the "Space free" setting? If that's not very much then there is nothing to be "shrunk")Kristen |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-01-31 : 03:45:08
|
| It sounds like you can't shrink your database because it is full of data. Contrary to what some people believe, the shrink only removes empty space, it doesn't compress actual data.If you are tight on space you should consider adding storage, as your database seems to have grown.-------Moo. :) |
|
|
|
Joozh
Posting Yak Master
145 Posts |
Posted - 2006-01-31 : 04:04:01
|
| Thanks for the replies (Kristen and mr_mist),'Right click Database : All tasks : Shrink :" gives "Space free" as 97.61 MB (6%)I guess it is the data (and not the empty space) and that's why shrinking is not doing what I was expecting. Ah welll... got to purchase a new HD or delete some of the old databases :(Thanks & Regards.-J |
|
|
|
|
|
|
Shrink does not reduce the database size