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 |
|
zeeshan13
Constraint Violating Yak Guru
347 Posts |
 Posted - 2010-08-26 : 15:01:14
|
| Hi All,I have a Database. I notice that it has some large size physical tables which I can remove without causing any issues to increase disk space on the drive. I am either truncating those tables or droping them. Either way the database size remain same although available free space size start increasing. How can I reduce the size of the database as soon as I truncate or drop a large table in the database? Please suggest.Thanks,Zee |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
zeeshan13
Constraint Violating Yak Guru
347 Posts |
Posted - 2010-08-26 : 15:10:21
|
| Thanks tkizer. Can you please get me the vode for DBCC SHRINKFILE? And which file I be shrinking?Thanks again. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Reduce DB size by truncating / droping tables?