SQL Server Backup Restore Automated Process

If you want to move the jobs from server A to Server B; follow what Grant suggested above to script out the jobs.

However when I read your question again it sounded to me you are looking for a way to create and schedule a backup job that runs on Server A but takes a backup of Server B. If thats the case you can create a Multiserver Maintenance Plan (create a package) on server A and select Server B to create the connection and select the databases you want to backup.

Good Luck!

To move a SQL Agent Job from one server to another, you just need to right click on the job in the first server, select "Script Job" and "As Create To" and select the appropriate place, say a new TSQL window. Then you connect to the new server, edit anything that is appropriate, say drive locations, and run the script on the new server. It will move over all the steps and the schedule for the entire job in one fell swoop.

Hi Naina,

Please try Log-shipping. That is very reliable and less hassle for DBA.