Post reply

Moving Jobs from one sql server 2005 to another sql server 2005

  • December 22, 2008 at 3:51 am

    #195363

    Hello,

    I need to copy all 120 jobs from one sql server 2005 to another sql server 2005, there is anyway to do this task fast?

    thanks

    nelson

  • December 22, 2008 at 4:23 am

    #916044

    Hi

    One way is, create script for each job using management studio one by one. And second is, you can write t-SQL script which quries dbo.sysjobs, dbo.sysjobschedules and dbo.sysjobsteps table of msdb database and generated the script for all jobs.

    Best Regards

    Nitin Patel

    http://www.EnlinkURL.com

    Regards,
    Nitin

  • December 22, 2008 at 4:24 am

    #916045

    Either create scripts for all the jobs or use the Transfer Jobs task in SSIS.

    [font="Verdana"]Markus Bohse[/font]

  • December 22, 2008 at 4:31 am

    #916048

    Hi,

    Yes i´m using the create scritp BUT when I run it on the second server i´m getting this error:

    A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - Uma conexão estabelecida foi anulada pelo software no computador host

    what is this?

    thanks

  • December 22, 2008 at 4:36 am

    #916050

    In ur SSMS, Go to SQL Server Agent -> Jobs

    right click jobs -> click Tasks -> Generate Scripts.

    Once u've your scripts ready, run those on ur target DB after u've restored all databases.


    Pradeep Singh

  • December 22, 2008 at 5:02 am

    #916060

    Incidently i too got that error when i tried to fire some queries after restoring DBs. i ran my query again and didnt get the error again 😉


    Pradeep Singh

  • December 22, 2008 at 5:21 am

    #916065

    Thank you, I got it...

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply