[Bug] Backup to URL with Folder Fails with Error

[jdanton]

Before submitting a bug report:

Collect output of following command and paste below:

Backup-DbaDatabase -SQLInstance 'VM1'
-FileCount 4 -CompressBackup
-CreateFolder -AzureBaseURL 'https://backupdemo.blob.core.windows.net/backups/'
-SQLCredential $cred

[14:27:24][Backup-DbaDatabase] Backup Failed | System.Data.SqlClient.SqlError: The file name 
"https:\backupdemo.blob.core.windows.net\backups\master\master_201904091427-1-of-4.bak" is invalid as a backup device 
name for the specified device type. Reissue the BACKUP statement with a valid file name and device type.
[14:27:24][Backup-DbaDatabase] Backup Failed | System.Data.SqlClient.SqlError: The file name 
"https:\backupdemo.blob.core.windows.net\backups\model\model_201904091427-1-of-4.bak" is invalid as a backup device 
name for the specified device type. Reissue the BACKUP statement with a valid file name and device type.
[14:27:24][Backup-DbaDatabase] Backup Failed | System.Data.SqlClient.SqlError: The file name 
"https:\backupdemo.blob.core.windows.net\backups\msdb\msdb_201904091427-1-of-4.bak" is invalid as a backup device name 
for the specified device type. Reissue the BACKUP statement with a valid file name and device type.

& {"### PowerShell version:`n$($PSVersionTable | Out-String)"; "`n### dbatools Module version:`n$(gmo dbatools -List | select name, path, version | fl -force | Out-String)"}

dbatools 0.9.802

• Running latest release of dbatools
• Verified errors are not related to permissions
• Is this bug with Copy-DbaDatabase? You can replicate it using Backup-DbaDatabase ... | Restore-DbaDatabase ...

NOTE: Copy-DbaDatabase will not work in every environment and every situation. Instead, we try to ensure Backup & Restore work in your environment.

Environmental data

Running in the context of Azure Automation Runbook.

<# REPLACE WITH output OF environment one-liner #>

SQL Server:

/* REPLACE WITH output of @@VERSION */

Microsoft SQL Server 2017 (RTM-CU13) (KB4466404) - 14.0.3048.4 (X64) Nov 30 2018 12:57:58 Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Windows Server 2016 Datacenter 10.0 (Build 14393: ) (Hypervisor)

Errors Received

<# OUTPUT of $error[0] | select * #>

Steps to Reproduce

/*
    Any T-SQL commands involved or used to produce test objects/data.
*/

<#
    Provide exact (or sanitized) code to reproduce the error


 Backup-DbaDatabase `
        -SQLInstance 'VM1'`
		-FileCount 4  `
		-CompressBackup `
        -CreateFolder `
		-AzureBaseURL 'https://backupdemo.blob.core.windows.net/backups/'`
        -SQLCredential $cred

#>

## Expected Behavior

<!--
Sample output or detail explanation if possible
-->

## Actual Behavior

<!--
Output or detailed explanation if possible
-->

[wsmelton]

We do not support creating folders in Azure Storage via the Backup command. We will need to update the code to throw if the CreateFolder parameter is provided with the -AzureBaseURL.