I need to run a command file to copy database backup files to a backup server. Both server are Windows 2008 R2. Task does run, but all file copy's fail. Running the command file manually works. I have tried creating the task with
both of the commands below and made every change to bump priority using GUI that I can see to do and nothing works.
Thank you, Santosh. But that did not solve the problem. The batch file does run correctly, but the network file copy specified in the batch file does not work. Even xcopy from local drive to same drive, but using the network, fails (D:
and \\adv1\D are the same).
echo f |xcopy "D:\MSSQL\backup\Backup_ADVdb.bak" "\\adv1\D\MSSQL\ADVdb_copy.bak" /D /Y
The network is local and in a workgroup, not a domain.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.