O'Reilly logo

Practical Maintenance Plans in SQL Server: Automation for the DBA by Bradley Beard

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Bradley Beard 2016

Bradley Beard, Practical Maintenance Plans in SQL Server, 10.1007/978-1-4842-1895-2_9

9. Shrinking the Database and Files

Bradley Beard

(1)Palm Bay, Florida, USA

Ever get the feeling that things are just getting too big for you to handle? Wondering why your database, which doesn’t seem very big, all of a sudden is much larger than you remember? There are lots of reasons why this could be, not to mention that there is simply more data in there than you realize. Do you need to add a shrink task to your maintenance plan? Let’s take a look and find out.

Disk Usage Reporting

Right-click your database name and choose Reports ➤ Standard Reports ➤ Disk Usage. It takes a second to run, and then you get a cool little graphic similar to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required