ohemaa
asked on
Job schedules move files
I have to schedule the following as jobs
1.backup Db Customer to \\serverA\backups\customer complete.b ak
2.move the file to another server \\serverA\backups\customer complete.b ak To \\serverb\backups\customer complete.b ak
Step 2
Move "\\serverA\backups\custome rcomplete. bak " "\\serverb\backups\custome rcomplete. bak"
Job schedule :
Step one is done
I used move to accomplish step 2. No luck
1.backup Db Customer to \\serverA\backups\customer
2.move the file to another server \\serverA\backups\customer
Step 2
Move "\\serverA\backups\custome
Job schedule :
Step one is done
I used move to accomplish step 2. No luck
As Yveau says...
The account that is used to run the Windows Service - Server SQL Server Agent must have write permissions to the backups folder on server B. IF using move then it also needs to have delete (or modify?) permissions on the backup folder on server A.
The account that is used to run the Windows Service - Server SQL Server Agent must have write permissions to the backups folder on server B. IF using move then it also needs to have delete (or modify?) permissions on the backup folder on server A.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The above would assume that the account running SQL Agent has the necessary permissions to run xp_cmdshell
ASKER
I get the WARNING: The following job steps cannot be reached with the current job step flow logic.
[2] Move File to ServerB
Is this the intended behavior?
[2] Move File to ServerB
Is this the intended behavior?
NO, is it two separate job steps (backup, then move. If so, you'll need to check your workflow and make sure that after successful completiong of step 1, you execute the next step.
Enough permissions for the SQL Server Agent account, as that is the account that performs your jobs for you ?
Hope this helps ...