Can no longer restore from network share

brosato

Since I upgraded to 5.4, I can't restore a database from a network location. It will add the server but I can't browse any directories.

priyasinha

Hi,

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

brosato

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

brosato

I just noticed this

execute master..sqbdir '\\recovery' gives me a listing

execute master..sqbdir '\\recovery\' does not.

priyasinha

Hi,

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