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 |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2005-10-17 : 10:17:20
|
| I was just reading a doc on SQL , that said that to free up the unused space from the DB , you should use the shrinkdatabase DBCC commnad. ....I want to knw how to determine how much free unused space is there in a DBThanks, |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-17 : 11:04:22
|
| In Enterprise Manager if you do:Right Click the DBAll tasksShrink Databasethen the dialog box that pops up shows you the free space. (You can cancel the "Shrink" at that point)Kristen |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-18 : 00:46:57
|
| Also run sp_spaceused in Query Analyser to know the space used by the DatabaseMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Free UNUSED SPACE