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

olafhelper

Nov 02, 2023

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]

Forum Discussion

Maintenance plan missing after editing in a second window

Resources