locked
Migrating SQL maintenance plans from one server to another RRS feed

  • Question

  • Hello,

    I am trying to migrate SQL maintenance plans from one server to another. The current server is Windows 2012 R2 Standard with SQL 2014 (12.0.4213.0) Standard. The new server is Windows 2016 Standard with SQL 2017 Standard (14.0.1000.169).

    I have used SSIS to export a maintenance plan, modified the connection string in the DTSX file, then imported it into the new server. The import process succeeds and when I execute it (it is a backup job with a UNC path as the target), it completes successfully in 1 second but it does not do anything. The job history shows no entry.

    Is there a better way to do this as I have over 50 maintenance plans to migrate? If I have to do this one by one, then what else do I need to do to make this work on the target server? Both servers are in the same network in the same domain with different names and IP's.

    Regards,

    Rudy


    Wednesday, September 12, 2018 11:21 PM

All replies

  • Hi Rudolf Amarlapudi,

     

    From your description, I know that you exported, imported a maintenance plan and also executed the job successfully. So the approach that migrating SQL maintenance plans via SSIS worked well. And it is recommended to use SSIS to migrate SQL maintenance plans from one server to another.

     

    Could you please check if there are some judgements which lead to the job skip the backup operation in the job command. In addition, please try to migrate another maintenance plan to the target server and tell us whether the job can do well in it.

     

    Best Regards,

    Emily


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com


    Thursday, September 13, 2018 9:53 AM
  • What do you mean by judgments? I have tried exporting and importing multiple maintenance plans and they do nothing.
    Thursday, September 13, 2018 6:12 PM
  • Hello, can you please explain what you mean by judgments?
    Tuesday, September 18, 2018 8:40 PM
  • Anybody?
    Thursday, September 20, 2018 3:54 PM