| Miguel Castanuela 2006-02-09, 8:23 pm |
| I'm planning run a batch ( c:\CopyBkp.bat ) in a basis daily-night,
basically it makes a copy of my full backup files on another machine
in the net. The batch runs fine executed from a cmd window,
but from Query analyzer (testing purpose) the instruction
EXEC master.dbo.xp_cmdshell 'copy d:\backup_data\myDB_
db_200602090135.bak
\\Machine\TargetDir\
'
(same instruction of the batch file which run ok)
the output says 'Denied Acces'
I wish run through xp_cmdshell because i need build
dinamic strings (obviously due to the file name of my backup files)
Which is the solution to this problem?
How to configure the permissiones of the shared folder
on the another machine (another Win2000 Server) referencing
the 'services' account' of the external, source server?
Is ok promote the "X service account " (which is it?)
to Adminstrator's Group to solve the problem?
Please elaborate.
Thanks in advance,
Miguel Castanuela
|