If I do execute master..sqbdir '\\recovery' I get the directory listing at the share level. If I go execute master..sqbdir '\\recovery\sqlbackups' it doesn't return anything and it should. I'm running this from my machine and I'm admin on \\recovery. This used to work until 5.4
Thanks for reporting this. We are trying to reproduce it here but no success yet. We will keep investigating it but for the time being the work around is to type the path manually and if the permissions are correct then it will work.
Comments
Sorry for the inconvenience.
Can you please try running the query below and check whether it returns the list of folders on that network location or not?
execute master..sqbdir '\\servername'
The UI lets you add any network share but it wont display the list of folders if the appropriate permissions are not present.
You can also try typing the backup file path manually and check if that works.
Thanks,
Priya
Project Manager
Red Gate Software
execute master..sqbdir '\\recovery' gives me a listing
execute master..sqbdir '\\recovery\' does not.
Thanks for reporting this. We are trying to reproduce it here but no success yet. We will keep investigating it but for the time being the work around is to type the path manually and if the permissions are correct then it will work.
Sorry for the inconvenience.
Thanks,
Priya
Project Manager
Red Gate Software