Competition: What’s your favorite Redgate tool? Enter now.

Extended stored procedure not working over network

vibrantchrisvibrantchris Posts: 2
edited July 27, 2007 4:00AM in SQL Backup Previous Versions
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

Comments

  • 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.