© 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 ...

Get Practical Maintenance Plans in SQL Server: Automation for the DBA now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.