How can we help you today? How can we help you today?

Extended stored procedure not working over network

Hi

I am trying to run the sql backup extended stored procedure across a network share.

EXEC master.dbo.xp_cmdshell 'net use N: \\LON-NAS01\Backups\SQLFullBackups /USER:username password'

master..sqlbackup N'-SQL "RESTORE FILELISTONLY FROM DISK = ''n:\FULL_DEV_Chris_test_20070718_154741.sqb''"'

EXEC master.dbo.xp_cmdshell 'net use n: /del'

If i use normal restore filelistonly t-sql command for a .BAK file in the same folder it works but when I run the above I get this:

Msg 1, Level 15, State 1, Line 0
Reading filelist of "n:\FULL_DEV_Chris_test_20070718_154741.sqb"

Error 530: File does not exist: (n:\FULL_DEV_Chris_test_20070718_154741.sqb)

SQL Backup exit code: 530


How do I get this extended stored procedure to work across the network?

cheers
Chris
vibrantchris
0

Comments

1 comment

Sort by
  • petey
    When you use the sqlbackup extended stored procedure, it runs using the user credentials of the SQL Backup service startup user. This needs to be a user that has access to the network share.
    petey
    0

Add comment

Please sign in to leave a comment.