reason: The system cannot find the file specified

Posted on 2009-06-30
Medium Priority
Last Modified: 2012-05-11
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.

Question by:info2rafiq
1 Comment
LVL 72

Accepted Solution

Qlemo earned 2000 total points
ID: 24752832
The SQL Agent has no network access. You have to change the service account to domain or other named account with access to the share, and that should do.

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question