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 |
|
dewacorp.alliances
452 Posts |
 Posted - 2006-10-13 : 00:27:40
|
| Hi there There is an option in Optimisation job that remove unused space from database file (shrink database when it grows beyond and amount of free space to remain after shrink).I heard that this option is not really recommended to apply. Is this correct? Any reason? In fact it's only running once a week.Thanks |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-10-13 : 00:53:35
|
| Yes...It's better not to excercise that option unless you are deleting heavy chunk of data from the database. There will increased IO and fragmentation after you do it.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-13 : 05:44:51
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Database%20Shrinking,Shrink,ShrinkingKristen |
|
|
|
|
|
|
Optimisation in Maintenance Plan