What If You Really DO Need to Shrink a Database?


You’ve heard that shrinking a database is bad because it introduces both external and internal fragmentation, it causes blocking, it causes transaction log growth while it runs, and it’s slow and single-threaded. You understand that if it’s just a matter of 10-20-30% of a database, and the database is only 100-200GB, you might as well just leave the space there, because you’re gonna end up using it anyway.

No, you don’t need to shrink your 50GB database

But your situation is different:

Your database is 1TB or larger You’ve deleted 50% of the data You have 500GB+ empty space You’re