What are the challenges you face when working across database platforms? Take the survey

Extended stored procedure not working over network

vibrantchrisvibrantchris Posts: 2
edited July 27, 2007 4:00AM in SQL Backup Previous Versions

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?



  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.