SQL 2005: Maintenance Plans Folder Not Found
Today I found myself in the situation where I wanted to add some maintenance plans under SQL 2005, but got an error that looked like “Cannot find folder \Maintenance.”
The short version is that, somehow, the entry for the Maintenance folder in MSBD got nuked. After some digging I found a forum thread with instructions on how to fix the problem.
All you need to do is run two SQL queries against MSDB.
1. Verify that the entry is lost:
exec sp_executesql N’exec [msdb].[dbo].[sp_dts_getfolder] @P1, @P2′,N’@P1 nvarchar(17),@P2 uniqueidentifier’,N’Maintenance Plans’,'00000000-0000-0000-0000-000000000000′
2. Recreate the entry:
exec sp_dts_addfolder ‘00000000-0000-0000-0000-000000000000′,’Maintenance Plans’,'08AA12D5-8F98-4DAB-A4FC-980B150A5DC8′
Many thanks to the original poster at the link above for providing the solution.