SQL Server Backup Restore Automated Process


Please let me know Methods or any documents which are avialable to schedule (thru Schedule Job ) Backup Restore JOB from One Server To another Server.

Thanks Naina

more ▼

asked Apr 07, 2010 at 07:58 AM in Default

Naina gravatar image

63 13 13 14

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

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!

more ▼

answered Apr 07, 2010 at 11:11 AM

DaniSQL gravatar image

4.9k 33 35 39

(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Apr 07, 2010 at 09:14 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

(comments are locked)
10|1200 characters needed characters left

Hi Naina,

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

more ▼

answered Apr 08, 2010 at 10:40 AM

Leo gravatar image

1.6k 54 56 58

Log shipping will not copy Jobs.
Apr 09, 2010 at 12:43 PM sp_lock
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 07, 2010 at 07:58 AM

Seen: 1986 times

Last Updated: Apr 07, 2010 at 09:08 AM