Can no longer restore from network share

brosatobrosato Posts: 89 Bronze 2
edited December 5, 2008 10:18AM in SQL Backup Previous Versions
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.
· Share on Twitter

Comments

  • priyasinhapriyasinha Posts: 548 Silver 1
    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
    Priya Sinha
    Project Manager
    Red Gate Software
    · Share on Twitter
  • brosatobrosato Posts: 89 Bronze 2
    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
    · Share on Twitter
  • brosatobrosato Posts: 89 Bronze 2
    I just noticed this

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

    execute master..sqbdir '\\recovery\' does not.
    · Share on Twitter
  • priyasinhapriyasinha Posts: 548 Silver 1
    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
    Priya Sinha
    Project Manager
    Red Gate Software
    · Share on Twitter
Sign In or Register to comment.