CMDExec Problem

[GKWilly]

I have jobs setup to copy my backup dump files to another server offsite. They all run fine apart from on which has now started to fail with an 'Access Denied' error.

My command is just

Copy E:\mssql2k\MSSQL$UNIT\BACKUP\mytuedump.bak \\fpstaff\2ks-unitsvr-backup$

All the working jobs are using the same command and running with the same account.

Is there something glaringloy obvious that I'm missing?

Many thanks


Gone Drinking

 

[Skittle]

Do they run at the same time?
There is a limit of the number of users that can connect to a share at any one time and maybe it's set to one when two
jobs are running at the same time?



Dazed and confused

 

[GKWilly]

I can't even force the job to run now when there no connections to the share. The jobs are setup to run one each day,

ie. the one that is failing is the tuesday job (have different backup devices for each day, db and log, so I can always restore to a specific day and use the log for point in time).

The jobs for the other days run fine and the tuesday one has failed for the past 2 weeks. I'm completely at a loss as to why!



Gone Drinking

 

[Skittle]

I'd try running the script for Tuesday independently of SQl Server and see if it works to see if its the script.
It would at least prove it is an SQL server issue one way or the other rather than something else.



Dazed and confused

 

[GKWilly]

Ah!, can't run it from cmd prompt so obviously I'm looking in the wrong place.

(Disengage keyboard, engage brain)

Gone Drinking

 

[Skittle]

Ahhha!!!!

So it's the script.

Let me know when you find it, sounds interesting.


Dazed and confused