Post reply

Issue related to moving SQL JOBS

  • June 30, 2009 at 4:59 am

    #133889

    Hi ,

    I am planning to move all my jobs from one sql 2005 to another SQL 2005 server . Any suggestions please .

    And is there any way I can achieve the same MSDB , but I am not sure if we can restore system database from one server SQL to another .

    Please help !!!

  • June 30, 2009 at 5:21 am

    #1017478

    You can script all the SQL agent jobs and run them against the destination server...

  • June 30, 2009 at 9:10 am

    #1017648

    David (6/30/2009)

    You can script all the SQL agent jobs and run them against the destination server...

    Scripting is the method I prefer for moving jobs. Although you can restore a backup of msdb on another instance, I usually avoid restoring system databases if I can help it. See "restoring system databases" in BOL for info.

    Greg

Viewing 3 posts - 1 through 2 (of 2 total)

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