Thor Logo dbatools

Growth

Set-DbaDbFileGrowth

Chrissy LeMaire (@cl), netnerds.net

Set-DbaDbFileGrowth View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Modifies auto-growth settings for database data and log files to use fixed-size increments instead of percentage-based growth. Description Configures database file auto-growth settings using ALTER DATABASE statements to replace default percentage-based growth with fixed-size increments. This prevents unpredictable growth patterns that can cause performance issues and storage fragmentation as databases grow larger.

Read more