data-konzept

'It’s a really common question: “How do I shrink my database?”

Luckily, there’s also a really common answer: “Don’t.”

…but what if you really have to?

Perhaps you just implemented data compression, and have 60% free space in your database.
Perhaps you just deleted a bunch of old data, and have significant free space in your database.
There are a handful of scenarios where you have free space in the database, you’ll never use it, and you need to shrink. Just don’t make a habit of it.

I’m not even going to talk about log files…that’s a totally different topic. We’re just talking about data files.'...

http://am2.co/2016/04/shrink-database-4-easy-steps/