Post reply

Migrating SQL Jobs

  • January 18, 2007 at 10:21 pm

    #122733

    Hello All

    I am migrating one database to another server. There are many jobs on the original server. How can I move all the jobs for one specific database to the new server?

    Thanks

    Andrew

  • January 19, 2007 at 3:20 am

    #684215

    Andrew

    If you can "see" one server from the other, use the Transfer Jobs task in DTS.  If you can't, use Enterprise Manager to generate scripts for each of the jobs.

    John

  • January 19, 2007 at 3:39 am

    #684223

    yes as told by the last user use DTS to transfer the jobs if u script out then use that remember to change the target server name parameter.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

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

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