In Chapter 3, I recommended that you never use the
Shrink Database task, and that advice stands firm. In this brief chapter, I will describe exactly what is meant by "shrinking a database," and why I advise against doing it using the
Shrink Database task in the Wizard. I will also explain the legitimate reasons to shrink your databases, and the right ways to do it.
A database is composed of at least two physical files: one
MDF (data) file where data is stored, and one
LDF (log) file, where the transaction log is located. A database can actually have more than two physical files but, for the sake of this discussion, we'll assume it comprises one
MDF file and one
When a new database ...