SQL backup ftp and restore Need new idea.

[Enrgy]

Hi Everyone.
Im new in this forum.
i need some help about sql, im working in a large company and we have many construction yards in the world we made a program and we are taking backup and restoring test machine, but now we need a automatic system what can i do for it.

system working like this im taking backup from foreign country and putting company ftp site and restoring to test machine. we are compressing the backup before putting ftp.

How can i do it easily.

[dickersonka]

Is it in the maintenance plan or a schedule task to do so?

My advice would be to create a maintenance plan to create the backup, and a scheduled task to compress it and ftp it

I don't understand completely where the problem is residing