Tuesday, July 24, 2007 1:30 AM
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.
Tuesday, July 24, 2007 2:01 AM
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.
Tuesday, July 24, 2007 4:13 AMModeratorjust 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....
Wednesday, July 25, 2007 10:13 AMModerator
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