question

Naina avatar image
Naina asked

SQL Server Backup Restore Automated Process

Hello,

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

sql-server-2008backuprestore
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DaniSQL avatar image
DaniSQL answered

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!

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered

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.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Leo avatar image
Leo answered

Hi Naina,

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

1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Log shipping will not copy Jobs.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.