Migrating jobs does not create the maintenance plans

  • I am migrating backup jobs from one server to another. I scripted out the agent jobs but it seems to not create the maintenance plan. Not sure if I am migrating these plans correctly

  • The agent job is just that, a job that calls the back up plans.  You need to migrate or create the backup plans themselves they won't migrate along with an agent job any more than a stored procedure called in an agent job would, how you do that will depend on what are using to do your backups.

  • Is there a way to migrate maintenance plans

  • keanyukas - Wednesday, February 27, 2019 6:33 AM

    Is there a way to migrate maintenance plans

    Yes.  Please see the following link. 😉 http://bfy.tw/MVmZ

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • keanyukas - Wednesday, February 27, 2019 6:33 AM

    Is there a way to migrate maintenance plans

    At one time - you could export the maintenance plans into an SSIS project, make the necessary changes - and save them to the new server.  However, with all of the changes in SSMS (Visual Studio) and SSIS that method may not work correctly - and isn't worth the time and effort.

    It is just as easy - and less time-consuming - to open the old maintenance plan from the old server, copy/paste everything in that subplan, paste in a new maintenance plan on the new server and fix up any issues with the tasks (e.g. reset list of databases, rebuild index options, etc...).

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

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

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