What is the easiest, simplest, and most secure way to tranfer one database, from a Production server, to the same database name on a Staging server?
It must be automated - so I can schedule it for 3am daily, and also click "Go" and run it on the fly.
It must also leave the Source (Production) available as this is a 24x7 environment.
My first thought, upon opening SSIS, was to use the "Transfer Database Task". But that is getting all weird on me. I cannot specify or create "DestinationDatabaseFiles" at all, and when I hit "OK" with what I have, the red-X circle is still on the task, complaining that "At least one source file must be specified". But there are 2 source files listed. So what is going on.
Thank you greatly.