April 28, 2006 at 12:34 pm
We can't afford enterprise edition, so I'm in the process of creating a home grown version.
I have a bat file that is suppose to bring over the trans logs from one server to another
Here's the inners
\\sql8\backup\hourly_tran_backup d:\move\dbs\hourly_tran_backup /Y
and I have saved it as 'TranLogDB.bat'
I created a job that is suppose to execute the bat file and then run a second step to load/rename the logs.
If I type the 'inners' on the cmd line I have no problem (logged in as admin).
Now when I put the bat file in a SQL Server job (using the CMDEXec), I get this error message
C:\WINNT\system32>xcopy \\sql8\backup\hourly_tran_backup d:\move\dbs\hourly_tran_backup /Y
Invalid drive specification
0 File(s) copied
Here's what happens when I cut and paste the command manually via a cmd window
C:\Documents and Settings\Administrator>xcopy \\sql8\backup\hourly_tran_backup d
:\move\dbs\hourly_tran_backup /Y
\\sql8\backup\hourly_tran_backup\AgentConnect2TranDump.BAK
1 File(s) copied
At first I thought it may have been a permissions issue with the SQL but the error message is telling me something different. - Invalid drive specification - The server I'm running the job on has a local system account.
It must be a permissions thing right?
April 28, 2006 at 1:19 pm
your sever (Agent Account) needs to be a 'domain account' to have access to a network resource. --> 'local system' can't
* Noel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply