Forum Discussion
Solved
Maintenance plan missing after editing in a second window
I was editing a maintenance plan, but I had the same plan already open in another window but not saved, and I just forgot and opened a second window of the same plan. When I saved the edits in th...
how can I restore the plan?
Leavii , the SSIS packages for maintenance plans are stored in system-database "msdb". If you have a good backup, you could restore it under a new name and copy over the missing informations
SELECT [name] ,[id] ,[description] ,[createdate] ,[folderid] ,[ownersid] ,[packagedata] ,[packageformat] ,[packagetype] ,[vermajor] ,[verminor] ,[verbuild] ,[vercomments] ,[verid] ,[isencrypted] ,[readrolesid] ,[writerolesid] FROM [msdb].[dbo].[sysssispackages]
I will give this a shot. I recreated the plan, but I know I will do this again as I have done it before. I feel like I remember doing something different to get the job back though. Doesn't seem to be an issue in SSMS 19, but 12 so I will just avoid that version going forward.
You should avoid maintenance plans as it at all, they have never been reliable.
Have always worked for me.