Expanding or shrinking a database
You can expand and shrink databases automatically or manually. The mechanism for automatic expansion is completely different from the mechanism for automatic shrinkage. Manual expansion is also handled differently from manual shrinkage. Log files have their own rules for growing and shrinking, as covered in Chapter 5.
Warning
Shrinking a database or any data file is an extremely resource-intensive operation, so don’t do it unless you absolutely must reclaim disk space. Shrinking a data file can also lead to excessive logical fragmentation within your database, as discussed in Chapter 7.
Automatic file expansion
Expansion can happen automatically to any one of the database’s files when that particular file becomes ...
Get Microsoft SQL Server 2012 Internals 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.
