Showing posts with label planexception. Show all posts
Showing posts with label planexception. Show all posts

Friday, February 10, 2012

Cannot find folder "\Maintenance Plans".

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?
--
PaulI 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
"Paul Zanbaka" wrote:

> 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