Moving Jobs

Question

Hi,

 

I am moving  DBs  from one server(say Server A) to other (say server B) & once everything moved i will rename  the  Server B to Server A.

-I am backing up from .bak file & .trn file.

 

Now, i am confused  here..

How  to trasnfer all jobs running on server  A to server B?

I am really novice to DTS.

 

If some one can throw  somelight  on that,that will really  helpfull for me.

 

 

With Regards.

 

Wasim

 

 

Answer 1

I'm not real clear on how you are moving the databases but you can script out the jobs on the old server and then execute the job scripts on the new server. If you are restoring msdb, script the jobs first, delete them on the new server after the restore and then execute the job scripts you created on the new server.

 

-Sue

Answer 2

just script the jobs and execute the script in new server......also you can restore the msdb in the new server in that case you dont need to script the jobs..........moreover you dont need to backup the trn file instead take a full backup and restore it in new server....

Answer 3

all server level objects like Logins/JObs/DTS has to be transfered explicitly.

 

(a) For dts you can use Save AS option or Save the DTS as filesystem object and transfer to Target server

(b) To tranfer the login you have a KB availbable in Microsfot site

(c) For Job , its always better to script the job from source and run it in target

 

Madhu