Backup-DbaServiceMasterKey - Support Custom Backup File Name

[serenefiresiren]

Summarize Functionality

TSQL Command allows specifying the file name when backing up the service master key. Backup-DbaServiceMasterKey currently automatically sets the filename. It would be nice to have the option here as well. Relates to #9484 , #9485

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

Yes

Technical Details

SQL Command

BACKUP SERVICE MASTER KEY
 TO FILE = 'c:\sqlbackup\MainServiceMaster.key'
 ENCRYPTION BY PASSWORD = 'S3cureP@ssword!sneeded'

Existing file name command, line 119 $filename = Join-DbaPath -SqlInstance $server -Path $Path -ChildPath "$fileinstance-servicemasterkey.key"

Suggested change adding an option Filename parameter

param (
        [parameter(Mandatory, ValueFromPipeline)]
        [DbaInstanceParameter[]]$SqlInstance,
        [PSCredential]$SqlCredential,
        [PSCredential]$KeyCredential,
        [Alias("Password")]
        [Security.SecureString]$SecurePassword,
        [string]$Path,
        **[string]$ChildPath,
        [Alias("FileName")]**
        [switch]$EnableException
    )
 #
 #
 #
 # pseudo
$ChildPath = $ChildPath or if null then $fileinstance-servicemasterkey.key" 
$filename = Join-DbaPath -SqlInstance $server -Path $Path -ChildPath $ChildPath 

[wsmelton]

Is there any difference to you just running Rename-Item after the command?

[serenefiresiren]

See #9485 for discussion