Install-DbaMaintenanceSolution: Add Parameter for @ChangeBackupType

[bs-sgr]

Summarize Functionality

I use the Install-DbaMaintenanceSolution function when installing my SQL and configure the SQL Server Agent jobs at the same time. For our log and diff backups, we have added the additional @ChangeBackupType = 'Y' to the jobs to make up for a missing full backup at the next backup attempt.
An extension of the Install-DbaMaintenanceSolution command to include the ChangeBackupType function would help us a lot to avoid having to adjust the jobs manually.

Is there a command that is similiar or close to what you are looking for?

Yes

Technical Details

We currently use the following command for installation

Install-DbaMaintenanceSolution -SqlInstance localhost -Database $Database -CleanupTime $CleanupTime -LogToTable -ReplaceExisting -InstallJobs -BackupLocation $BackupLocation

It would be possible, for example, to add the parameter -ChangeBackupType to the Install-DbaMaintenanceSolution command, e.g. to select that this function is required. This option can remain deactivated by default

Example of implementation
Install-DbaMaintenanceSolution -SqlInstance localhost -Database $Database -CleanupTime $CleanupTime -LogToTable -ReplaceExisting -InstallJobs -BackupLocation $BackupLocation -ChangeBackupType $true