I've been trying to schedule a database transfer from one SQL server to another
using SQL Enterprise Manager. It never works when I schedule it. I get the
message, "cannot connect to destination server." However, if I run the transfer
manually, it does work. Also, if I run it from the command line (XFRAGENT -i
"server" "database" "id") it works, but if I try to schedule it using AT, it
doesn't. It's as if AT doesn't process command parameters.
Does anyone know how to schedule a transfer successfully?
For more information about this list (including removal) go to: