http://blogs.msdn.com/buckwoody/archive/2009/07/01/sql-server-best-practices-auto-shrink-should-be-off.aspxSQL Server is one of the easiest databases to maintain because of all of the automatic settings it has, but as I mentioned with Auto-Close, some of them should be left off. The Auto-Shrink setting is another. That might surprise a few people. You mighten-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/buckwoody/archive/2009/07/01/sql-server-best-practices-auto-shrink-should-be-off.aspx#9856324Mon, 03 Aug 2009 18:50:35 GMT91d46819-8472-40ad-a661-2c78acb4018c:9856324hfrmobile<p>&quot;I never shrink my databases unless I have a huge deletion of data, and I know that the data won't come back.&quot;</p> <p>--&gt; I agree ;-) In my current project we have such a situation one time / year.</p>