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 |
|
kotsas
Yak Posting Veteran
65 Posts |
 Posted - 2002-03-08 : 07:24:04
|
| As we know when we delete row sql server live empty space in pages.So now my database is 80GB and when I MOVE it with DTS to other location is 50 GB. How can I defragment (delete physicaly) that empty space. Will clustered index defragmentation help.Thank |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-08 : 07:57:47
|
| DBCC SHRINKDATABASE allows you to defragment and remove excess space from your database file(s). It is documented in Books Online, read it carefully before you use it. You may need to perform the operation a few times before you reach the target size. |
 |
|
|
|
|
|
Defragment disk space