FileManagement

Invoke-DbaBalanceDataFiles

Invoke-DbaBalanceDataFiles View Source Sander Stad (@sqlstad), sqlstad.nl Windows, Linux, macOS Synopsis Re-balance data between data files Description When you have a large database with a single data file and add another file, SQL Server will only use the new file until it’s about the same size. You may want to balance the data between all the data files. The function will check the server version and edition to see if the it allows for online index rebuilds.