Can no longer restore from network share

• 
  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

  priyasinha December 05, 2008 06:30

  - 0 +
• 
  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 December 05, 2008 08:03

  - 0 +
• 
  I just noticed this
  
  execute master..sqbdir '\\recovery' gives me a listing
  
  execute master..sqbdir '\\recovery\' does not.

  brosato December 05, 2008 08:05

  - 0 +
• 
  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

  priyasinha December 05, 2008 10:18

  - 0 +

Add comment

Please sign in to leave a comment.