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.

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.