Extended stored procedure not working over network
vibrantchris
Posts: 2
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
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
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8