{"action":"created","issue":{"url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/3497","repository_url":"https://api.github.com/repos/sqlcollaborative/dbatools","labels_url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/3497/labels{/name}","comments_url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/3497/comments","events_url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/3497/events","html_url":"https://github.com/sqlcollaborative/dbatools/issues/3497","id":312233894,"number":3497,"title":"Backup-DBADatabase Fails to backup to URL with BackupFileName parameter specified","user":{"login":"johnmart82","id":32261850,"avatar_url":"https://avatars0.githubusercontent.com/u/32261850?v=4","gravatar_id":"","url":"https://api.github.com/users/johnmart82","html_url":"https://github.com/johnmart82","followers_url":"https://api.github.com/users/johnmart82/followers","following_url":"https://api.github.com/users/johnmart82/following{/other_user}","gists_url":"https://api.github.com/users/johnmart82/gists{/gist_id}","starred_url":"https://api.github.com/users/johnmart82/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/johnmart82/subscriptions","organizations_url":"https://api.github.com/users/johnmart82/orgs","repos_url":"https://api.github.com/users/johnmart82/repos","events_url":"https://api.github.com/users/johnmart82/events{/privacy}","received_events_url":"https://api.github.com/users/johnmart82/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"Stuart-Moore","id":5613670,"avatar_url":"https://avatars0.githubusercontent.com/u/5613670?v=4","gravatar_id":"","url":"https://api.github.com/users/Stuart-Moore","html_url":"https://github.com/Stuart-Moore","followers_url":"https://api.github.com/users/Stuart-Moore/followers","following_url":"https://api.github.com/users/Stuart-Moore/following{/other_user}","gists_url":"https://api.github.com/users/Stuart-Moore/gists{/gist_id}","starred_url":"https://api.github.com/users/Stuart-Moore/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Stuart-Moore/subscriptions","organizations_url":"https://api.github.com/users/Stuart-Moore/orgs","repos_url":"https://api.github.com/users/Stuart-Moore/repos","events_url":"https://api.github.com/users/Stuart-Moore/events{/privacy}","received_events_url":"https://api.github.com/users/Stuart-Moore/received_events","type":"User","site_admin":false},"assignees":[{"login":"Stuart-Moore","id":5613670,"avatar_url":"https://avatars0.githubusercontent.com/u/5613670?v=4","gravatar_id":"","url":"https://api.github.com/users/Stuart-Moore","html_url":"https://github.com/Stuart-Moore","followers_url":"https://api.github.com/users/Stuart-Moore/followers","following_url":"https://api.github.com/users/Stuart-Moore/following{/other_user}","gists_url":"https://api.github.com/users/Stuart-Moore/gists{/gist_id}","starred_url":"https://api.github.com/users/Stuart-Moore/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Stuart-Moore/subscriptions","organizations_url":"https://api.github.com/users/Stuart-Moore/orgs","repos_url":"https://api.github.com/users/Stuart-Moore/repos","events_url":"https://api.github.com/users/Stuart-Moore/events{/privacy}","received_events_url":"https://api.github.com/users/Stuart-Moore/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2018-04-07T19:06:24Z","updated_at":"2018-04-08T08:44:47Z","closed_at":null,"author_association":"NONE","body":"<!-- ERASE the section that is not applicable but please provide as much information as possible -->\r\n## Bug Report\r\n<!-- Please fill in the appropriate information below -->\r\n### General Troubleshooting steps\r\n\r\n- [x] Verified running the latest release of dbatools?\r\n- [x] Verified errors are not related to permissions?\r\n- [x] Can duplicate in new/clean PowerShell session (clean = `powershell -NoProfile`)?\r\n\r\n### Version Information\r\n - Operating System (Name|Version): See attached ComputerInfoOutput.txt file\r\n - PowerShell Version: 5.1.14393.1944\r\n - SQL Server (Edition|Version): Microsoft SQL Server 2017 (RTM-CU3-GDR) (KB4052987) - 14.0.3015.40 (X64)   Dec 22 2017 16:13:22   Copyright (C) 2017 Microsoft Corporation  Developer Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor) \r\n\r\n## Steps to Reproduce\r\n<!--  \r\n  PLEASE include as much information as possible if this is a bug report.\r\n  The more you include the faster we can identify the problem and get it fixed\r\n-->\r\n - [x] Attach any screenshots (if possible/allowed)\r\n - [ ] Attach logs generated by dbatools (`Get-DbatoolsLog`)\r\n - [x] Attach output from PowerShell console (if possible/allowed)\r\n\r\nAttached screenshot of PowerShell window that has log entries, backup command and verbose output.\r\n![image](https://user-images.githubusercontent.com/32261850/38459181-a59e9056-3a74-11e8-82da-bde623c706a5.png)\r\n\r\nIssue Backup-DBADatabase command that backs up to URL and uses the BackupFileName parameter, example as follows;\r\n\r\nBackup-DbaDatabase -SqlInstance winsql-0 -AzureBaseUrl https://<StorageAccountName>.blob.core.windows.net/databasebackups/ -Type Full -Database SalesArchive -BackupFileName salesarchivebackup.bak -Verbose\r\n\r\nThis results in the following error being reported;\r\nWARNING: [Backup-DbaDatabase][18:59:56] SQL Server cannot write to the location https:\\\\<StorageAccountName>.blob.core.windows.net\\databasebackups\r\n\r\nThe backup does not take place.\r\n\r\n### Problem to solve\r\nAllow database backup file name to be specified when backing up to URL.\r\n\r\n### Additional information\r\n[ComputerInfoOutput.txt](https://github.com/sqlcollaborative/dbatools/files/1886642/ComputerInfoOutput.txt)\r\n"},"comment":{"url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/comments/379532359","html_url":"https://github.com/sqlcollaborative/dbatools/issues/3497#issuecomment-379532359","issue_url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/3497","id":379532359,"user":{"login":"potatoqualitee","id":8278033,"avatar_url":"https://avatars1.githubusercontent.com/u/8278033?v=4","gravatar_id":"","url":"https://api.github.com/users/potatoqualitee","html_url":"https://github.com/potatoqualitee","followers_url":"https://api.github.com/users/potatoqualitee/followers","following_url":"https://api.github.com/users/potatoqualitee/following{/other_user}","gists_url":"https://api.github.com/users/potatoqualitee/gists{/gist_id}","starred_url":"https://api.github.com/users/potatoqualitee/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/potatoqualitee/subscriptions","organizations_url":"https://api.github.com/users/potatoqualitee/orgs","repos_url":"https://api.github.com/users/potatoqualitee/repos","events_url":"https://api.github.com/users/potatoqualitee/events{/privacy}","received_events_url":"https://api.github.com/users/potatoqualitee/received_events","type":"User","site_admin":false},"created_at":"2018-04-08T08:44:47Z","updated_at":"2018-04-08T08:44:47Z","author_association":"OWNER","body":"Ty John!"}}
{"actor":{"display_login":"potatoqualitee"}}