Groups | Blog | Home
all groups > sqlserver server > october 2006 >

sqlserver server : Cannot find folder "\Maintenance Plans".


Paul Zanbaka
10/25/2006 3:04:02 PM
After upgrading SQL 2000 to SQL 2005
I get this error when trying to create a maintenance plan:
Exception has been thrown by the target of an invocation. (mscorlib)
Cannot find folder "\Maintenance Plans".

I tried unistalling and reinstalling mgmt tools.
Any ideas?
--
Paul Zanbaka
10/25/2006 3:11:02 PM
I found a solution
use msdb
Verify that the folder is missing:
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'

Add the folder if missing:
exec sp_dts_addfolder '00000000-0000-0000-0000-000000000000','Maintenance
Plans','08AA12D5-8F98-4DAB-A4FC-980B150A5DC8'

It worked Thanks everybody anyways
--
Paul


[quoted text, click to view]
AddThis Social Bookmark Button