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 |
|
acko
Yak Posting Veteran
52 Posts |
 Posted - 2004-03-08 : 05:44:38
|
| HiMy database is 30GBWhen i drop some tables, one was 4GB, and shrink database, size of database remained 30GB.Why database is not now 24GB?Thanksalex |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-03-08 : 09:04:19
|
| Run a checkpoint on the database and shrink each file individually. You should be fine then.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
acko
Yak Posting Veteran
52 Posts |
Posted - 2004-03-08 : 09:15:41
|
| What do you mean with: Run a checkpoint on the database ? |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-03-08 : 20:28:49
|
| type in CHECKPOINT on the Index tab of Books Online. It explains it pretty well.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
DB Size