Redgate SQLBackup Extended Stored Procedure working across the network

• Wedge78

  Ten Centuries

  Points: 1102

  More actions

  July 26, 2007 at 10:03 am

  #117794

  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

• Ray Mond

  SSCertifiable

  Points: 7159

  More actions

  August 3, 2007 at 5:49 am

  #724467

  You need to ensure that the SQL Backup service startup user has rights to access the network share.

  SQL BAK Explorer - read SQL Server backup file details without SQL Server.
  Supports backup files created with SQL Server 2005 up to SQL Server 2017.