My aim: To simply mirror a database backup directory onto another server
Approach: Use Robocopy statement contained in a scheduled task
robocopy "C:\MylocalDirBackup" "\\MY.IP\DatabaseBackupsShare" /mir /z /log:"C:\MyLocalDIR\RobocopyTestLog.txt"
- Windows Server 2008R2
- Scheduled task user "MylocalUser": Local adminon local machine
- Network config: Both servers on workgroup
- navigate to share \MY.IP\DatabaseBackupsShare as "MylocalUser" - success, no prompt for credentials
- Run robocopy command from command line when logged on as "MyLocalUser" - success
The Problem!: When running Robocopy command from a scheduled task the following error is raised:
2013/10/22 20:04:57 ERROR 1326 (0x0000052E) Accessing Destination Directory \\MY.IP\DatabaseBackupsShare\ Logon failure: unknown user name or bad password.
I found several other people who are having similar problems, and followed suggestions here: http://social.technet.microsoft.com/Forums/scriptcenter/en-US/b591346e-3ed0-4ed1-9453-24851ebe1bb1/scheduling-robocopy-to-run-at-system-startup?forum=ITCG
Any help gratefully received. I thought this was going to be a quick task...