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 |
|
AsimKhaliq
Yak Posting Veteran
94 Posts |
 Posted - 2005-08-31 : 11:33:41
|
| HiMy database, Data file is about 4.5GB, which i think is too big as compare to the amount of data and my other databases, Although log file is only 10MB. Can someone help me in reducing the file size if possible. Please tell me in detailThanksAsim |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-08-31 : 11:53:01
|
| Use DBCC SHRINKDATABASE (YourDatabaseName). This will move the data in the files and then truncate unused space at the the end. If you have figured an efficient size, you can also specify a percentage of free space to leave at the end so that you don't immediately incur the overhead of the database resizing (auto-grow) to fit new data being added.---------------------------EmeraldCityDomains.com |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-01 : 01:21:17
|
| If you use the Shrink function in Enterprise Manager it will tell you how much "free space" exists beforehand, so you can then choose whether a Shrink is going to be worthwhile, or not.Kristen |
|
|
|
|
|
|
Database Size