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]
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.