Post reply

copying sql jobs

  • August 9, 2005 at 12:23 pm

    #88429

    I am planning to copy my database onto a different Box. So for that I am restoring the backup of the database and restoring it on the new Box. But the question is that there are lot of sql jobs associated with DB. SO how can I copy them onto my new Box.

    Thanks.

  • August 9, 2005 at 12:39 pm

    #580833

    msdb should contain all your jobs

    Mathew J Kulangara
    sqladventures.blogspot.com

  • August 9, 2005 at 1:54 pm

    #580848

    I usually have Enterprise manager generate a sql script.

    Right click on job all tasks Generate sql script.

    Use that script on new server, also serves as a backup in case something happens to the sql server.

     

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

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