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

No comments:

Post a Comment