Posted by shark on 02/19/07 14:04

Hi all,

i have sql servr 2000 standard edition.
robocopy is a step in one of the jobs. this step fails in the job
where as when i run it from command prompt the same command exceutes
succesfully. i have given the owner of the job as sa. acctaully wheni
see the files have been copied to the server succesfully but still
this step is shown as failed in the job.



Executed as user: PRODUCTION\SVC_SQL025. ...--------- ROBOCOPY v
1.96 : Robust File Copy for Windows NT
----------------------------------------------------------------------
Started : Mon Feb 19 09:00:33 2007 Source : G:\server\data\mssql
\BACKUP\RRU\AWDDATA\ Dest : \\sgcfhpsql25\g$\server\data\mssql
\LogShipping\awddata\AWDDATA_DB_BACKUP\ Files : *.*
Options :*.* /R:1000000 /W:30
---------------------------------------------------------------------
2 G:\server\data\mssql\BACKUP\RRU\AWDDATA\
New File 1166963200 AWDDATA_db_200702190900.BAK 0.0%
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.1%
0.1% 0.1% 0.1% 0.1% 0.1% 0.1% 0.1% 0.1% 0.1% 0.1%
0.1% 0.1% 0.1% 0.1% 0.1% 0.1% 0.1% 0.1% 0.2% 0.2%
0.2% 0.2% 0.2% 0.2% 0.2% 0.2% 0.2% 0.2% 0.2% 0.2%
0.... Process Exit Code 1. The step failed.

Can any body guide me?

thanks for the help.

Shark.

• Next in forum: Re: sql server 2000 robo copy
• Prev in forum: Re: count records in several months
• Thread view: sql server 2000 robo copy

[Reply to this message]