{"action":"created","issue":{"url":"https://api.github.com/repos/ctrlbold/dbatools/issues/28","repository_url":"https://api.github.com/repos/ctrlbold/dbatools","labels_url":"https://api.github.com/repos/ctrlbold/dbatools/issues/28/labels{/name}","comments_url":"https://api.github.com/repos/ctrlbold/dbatools/issues/28/comments","events_url":"https://api.github.com/repos/ctrlbold/dbatools/issues/28/events","html_url":"https://github.com/ctrlbold/dbatools/issues/28","id":162946856,"number":28,"title":"Restore-HallengrenBackup doesn't work with Path character \"$\"","user":{"login":"timw-be","id":20208406,"avatar_url":"https://avatars.githubusercontent.com/u/20208406?v=3","gravatar_id":"","url":"https://api.github.com/users/timw-be","html_url":"https://github.com/timw-be","followers_url":"https://api.github.com/users/timw-be/followers","following_url":"https://api.github.com/users/timw-be/following{/other_user}","gists_url":"https://api.github.com/users/timw-be/gists{/gist_id}","starred_url":"https://api.github.com/users/timw-be/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/timw-be/subscriptions","organizations_url":"https://api.github.com/users/timw-be/orgs","repos_url":"https://api.github.com/users/timw-be/repos","events_url":"https://api.github.com/users/timw-be/events{/privacy}","received_events_url":"https://api.github.com/users/timw-be/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-06-29T14:55:14Z","updated_at":"2016-07-17T22:01:56Z","closed_at":null,"body":"Hi,\r\n\r\nThe Restore-HallengrenBackup function fails when trying to restore databases from a file share with character \"$\" in it's path.\r\n\r\nWhen using Ola Hallengren's backup script to backup databases in an Availability Group, the backup files are stored in a folder with naming format \"cluster_name$availability_group_name\". The files are also named using naming format \"cluster_name$availability_group_name_databasename_FULL_COPY_ONLY_20160627_213000.bak\"\r\n\r\nBasically, I receive the following error:\r\nFile list could not be determined. This is likely due to connectivity issues or tiemouts with the SQL Server, the database version is incorrect, or the SQL Server service account does not have access to the file share. Script terminating.\r\n\r\nThere's no issue with SQL server timeouts or service accounts access rights.\r\n\r\nWhen I create a different folder (as a test) without a $ character in the same fileshare, copy a few database backups and remove the \"$\" in the copied backup files and point the Restore-HallengrenBackup function to this test folder on the fileshare restores work flawlessly.\r\n\r\nBasically, the \"$\" character that Hallengren's backup script adds in the backup file path as a replacement of \"\\\" breaks your restore script. Is there a way to mitigate this issue?\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/ctrlbold/dbatools/issues/comments/233206759","html_url":"https://github.com/ctrlbold/dbatools/issues/28#issuecomment-233206759","issue_url":"https://api.github.com/repos/ctrlbold/dbatools/issues/28","id":233206759,"user":{"login":"ctrlbold","id":8278033,"avatar_url":"https://avatars.githubusercontent.com/u/8278033?v=3","gravatar_id":"","url":"https://api.github.com/users/ctrlbold","html_url":"https://github.com/ctrlbold","followers_url":"https://api.github.com/users/ctrlbold/followers","following_url":"https://api.github.com/users/ctrlbold/following{/other_user}","gists_url":"https://api.github.com/users/ctrlbold/gists{/gist_id}","starred_url":"https://api.github.com/users/ctrlbold/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ctrlbold/subscriptions","organizations_url":"https://api.github.com/users/ctrlbold/orgs","repos_url":"https://api.github.com/users/ctrlbold/repos","events_url":"https://api.github.com/users/ctrlbold/events{/privacy}","received_events_url":"https://api.github.com/users/ctrlbold/received_events","type":"User","site_admin":false},"created_at":"2016-07-17T22:01:56Z","updated_at":"2016-07-17T22:01:56Z","body":"Should be fixed :) Try now"}}
{"actor":{"display_login":"ctrlbold"}}