Post reply

Moving SQL Jobs to Another Server

  • August 6, 2007 at 10:32 am

    #179937

    Hello All,

    I have moved a sql 2000 database to a different server, I now need to move all the SQL jobs and Maintenance Plans. How can I do this? What system tables must I replicate? They need to go from one 2000 box to another 2000 box. Can I create a DTS Package to do this?

    Thanks

    Andrew

  • August 6, 2007 at 10:37 am

    #724909

    For the jobs, just right-click on Jobs in EM and generate a SQL Script.  You'll have to set your Maintenance plans up manually.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • August 7, 2007 at 2:50 am

    #725043

    I'd follow John's advice.

    However, for reference, job information will be stored in the msdb database.

  • August 8, 2007 at 11:32 am

    #725499

    Check the job script whether contains source server name, you may have to replace it with the target server name.

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

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