Do Not Enable AUTO_SHRINK

Leave a comment

June 5, 2013 by Mike Hillwig

I was looking at syntax of DBCC SHRINKDATBASE today and came across a little gem. Yes, I’m shrinking. I’m also doing it to recover close to a terabyte of storage. But I’m staying in control of when we shrink.

Looking at the MSDN page with the syntax, I came across this little nugget of truth.

SHRINKDB Best Practices

 

Let me copy and paste the text so that the search engines pick this up, too.

Unless you have a specific requirement, do not set the AUTO_SHRINK database option to ON.

Countless people have documented this before, myself included. Microsoft is saying it. Please disable AUTO_SHRINK. Now. Please.

And then after you disable AUTO_SHRINK, please look at your indexes. They’re probably a mess.

Leave a Reply

Your email address will not be published. Required fields are marked *