CompressBackup option to Add-DbaAgDatabase

[cdbunch72]

Summarize Functionality

When using the manual seeding mode with backup and restore it would be nice to have the option to compress the backup as the shared path may not be as large as the regular backup location.

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

No

Technical Details

When calling Backup-DbaDatabase in the Add-DbaAgDatabase function it would be useful if you could specify -CompressBackup

[wsmelton]

I would recommend this be added as an input object to pass advanced parameters to the Backup call. In place of us having to add all the possible parameters the command accepts to this AG command.

$addParams = @{
    SqlInstance = 'sql2017a'
    AvailabilityGroup = 'ag1'
    ....
    AdvancedBackupParams = @{
        CompressBackup = $true
        FileCount = 6
    }
}
Add-DbaAgDatabase @addParams

Each call to Backup-DbaDatabase would adding that splatted object: @AdvancedBackupParams

dbatools/functions/Add-DbaAgDatabase.ps1

Lines 284 to 287 in bbccbfb

	Write-Message -Level Verbose -Message "Taking full and log backup of database $($db.Name)."
	$fullbackup = $db | Backup-DbaDatabase -BackupDirectory $SharedPath -Type Full -EnableException
	$logbackup = $db | Backup-DbaDatabase -BackupDirectory $SharedPath -Type Log -EnableException
	$backups = $fullbackup, $logbackup

One-off test shows it should work:

function t {param([psobject]$AdvancedInput) Get-Process @AdvancedInput}
t -AdvancedInput @{Name = 'pwsh'}

[andreasjordan]

Good idea, will put that on my to do list...

[andreasjordan]

I had some spare minutes...