{"id":2315,"date":"2016-10-18T15:06:29","date_gmt":"2016-10-18T13:06:29","guid":{"rendered":"http:\/\/blog.hosebei.ch\/?p=2315"},"modified":"2016-10-18T15:06:29","modified_gmt":"2016-10-18T13:06:29","slug":"sql-2016-export-maintenance-plan","status":"publish","type":"post","link":"https:\/\/blog.hosebei.ch\/?p=2315","title":{"rendered":"SQL 2016 &#8211; Export Maintenance Plan"},"content":{"rendered":"<p>Since I started to back up my System Center Configuration Manager Site within a SQL Maintenance Plan, I wondered how I would be able to export this Plan. To be able to restore the plan quickly, in case of failure, I wanted to export the maintenance plan. This starts by installing the Integration Services from the SQL Setup:<br \/>\n<a href=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql_maintenance_plan.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql_maintenance_plan.png?w=300\" alt=\"SQL Integration Services\" width=\"300\" height=\"225\" class=\"aligncenter size-medium wp-image-2316\" srcset=\"https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql_maintenance_plan.png 821w, https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql_maintenance_plan-300x225.png 300w, https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql_maintenance_plan-768x575.png 768w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><br \/>\n<!--more--><br \/>\nAfter the installation the setup requires you to restart the System, but it will not force the system to a reboot. When the Integration Services are installed, you can open the SQL Server Management Studio:<br \/>\n<a href=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql-management-studio.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql-management-studio.png?w=300\" alt=\"SQL Server Management Studio\" width=\"300\" height=\"199\" class=\"aligncenter size-medium wp-image-2318\" srcset=\"https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql-management-studio.png 499w, https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql-management-studio-300x199.png 300w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><br \/>\nIf you are missing the Management Studio on a 2016 Machine, this is normal, it does not come with the installation media. Refer to this Microsoft MSDN site to receive information and the download ling for the Management Studio 2016: <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt238290.aspx\" target=\"_blank\">Download SQL Server Management Studio (SSMS)<\/a><br \/>\nWhen the Management Studio is loaded, select &#8220;Integration Services&#8221; and add the Servername:<br \/>\n<a href=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql_maintenance_plan02.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql_maintenance_plan02.png?w=300\" alt=\"Integration Services\" width=\"300\" height=\"196\" class=\"aligncenter size-medium wp-image-2320\" srcset=\"https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql_maintenance_plan02.png 492w, https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql_maintenance_plan02-300x196.png 300w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><br \/>\nWithin the Object Explorer, Navigate to your maintenance plan, right-click on it and select Export Package:<br \/>\n<a href=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql_maintenance_plan04.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql_maintenance_plan04.png?w=290\" alt=\"Export Maintenance Plan\" width=\"290\" height=\"300\" class=\"aligncenter size-medium wp-image-2322\" srcset=\"https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql_maintenance_plan04.png 381w, https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql_maintenance_plan04-290x300.png 290w\" sizes=\"auto, (max-width: 290px) 100vw, 290px\" \/><\/a><br \/>\nYou can then select a Location where the Package should be stored:<br \/>\n<a href=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql_maintenance_plan05.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql_maintenance_plan05.png?w=300\" alt=\"Maintenance Package\" width=\"300\" height=\"210\" class=\"aligncenter size-medium wp-image-2323\" srcset=\"https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql_maintenance_plan05.png 613w, https:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql_maintenance_plan05-300x210.png 300w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><br \/>\nYou will now have a reimportable package of your maintenance Plan, you can even reimport the same maintenance plan:<br \/>\n<a href=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql_maintenance_plan06.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.hosebei.ch\/wp-content\/uploads\/2016\/10\/sql_maintenance_plan06.png\" alt=\"Integration Service\" width=\"266\" height=\"179\" class=\"aligncenter size-full wp-image-2324\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Since I started to back up my System Center Configuration Manager Site within a SQL Maintenance Plan, I wondered how I would be able to export this Plan. To be able to restore the plan quickly, in case of failure, I wanted to export the maintenance plan. This starts by installing the Integration Services from [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15,19,33,35],"tags":[],"class_list":["post-2315","post","type-post","status-publish","format-standard","hentry","category-configmgr","category-general","category-sccm","category-sccm-2012"],"_links":{"self":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/posts\/2315","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2315"}],"version-history":[{"count":0,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=\/wp\/v2\/posts\/2315\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2315"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2315"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.hosebei.ch\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}