View Single Post

   
  #3 (permalink)  
Old 02-29-2008, 07:49 AM
Simon Hayes
 
Posts: n/a
Default Re: transfer SQL Agent Jobs to new server


<bdtmike@hotmail.com> wrote in message
news:1111736982.251714.55010@f14g2000cwb.googlegro ups.com...
> I'm setting up a new SQL server. Is there a way to transfer the SQL
> Agent jobs from one server to the other?
>


You can either script out the jobs from Enterprise Manager (right-click, All
Tasks), or use the DTS Transfer Jobs task. You could also look at setting up
the existing server as a master server and the new one as a target server -
see "Multiserver Administration" in Books Online.

Simon


Reply With Quote