I am trying to copy a .bak file nightly from Server A to Server B. Can I do that using SQL server Job Agent to run this every night? I am thinking of adding the copy command as a statement within a step of a job. Something like: 'copy "G:\source\folder\" "\target\folder\"' inside the step and setting the type to Operating System(CmdExec). Is there a way to do it?I am trying to copy a .bak file nightly from Se