locked
The system cannot find the file specified RRS feed

  • Question

  • Hi,

    I Created job in sql server 2005 for get backup form netbackup

    if i run this from command prompt it works fine.
    but same command run from sql server agent server (SQL server job) it giving error.

    Command used in sql server job step :

    exec master.dbo.xp_cmdshell '"\\RWC-VDBK01\C$\Program Files\Veritas\NetBackup\bin\dbbackex"  
    -f \\RWC-VDBK01\N$\NetBackup\Admin_NB_Full.bch -p bkup_RWC-VDBK01-DB01_Admin_Full -np'

    Error getting
    reason: The system cannot find the file specified)

    Please any body give proper command to run backup from netbackup by using sql server job.

    Thanks
    Rafeeque
    Tuesday, June 30, 2009 11:23 PM

All replies

  • Wrong forum for this - but the problem is likely that you are using the admin share (C$) - you have run xp_cmdshell as a Windows Administrator in order to use the admin share. A much better idea would be creating an explicit share.
    John Welch | www.mariner-usa.com | www.agilebi.com | ssisUnit.codeplex.com
    Wednesday, July 1, 2009 12:46 AM