Cannot find folder "Maintenance Plans".

oo0yuki0oo發表於2010-10-12

when I try to create a Maintenance Plan through the Wizard, I got error as belos:

TITLE: Microsoft SQL Server Management Studio
------------------------------
Exception has been thrown by the target of an invocation. (mscorlib)
------------------------------
ADDITIONAL INFORMATION:
Cannot find folder "Maintenance Plans".
------------------------------
Cannot find folder "Maintenance Plans".
------------------------------
BUTTONS:
OK
------------------------------

then I open profile and found

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'

check msdb.dbo.sysdtspackagefolders90

SELECT * FROM msdb.dbo.sysdtspackagefolders90 where foldername ='Maintenance Plans'

if there's show nothing

run below script in msdb:

exec sp_dts_addfolder '00000000-0000-0000-0000-000000000000','Maintenance Plans','08AA12D5-8F98-4DAB-A4FC-980B150A5DC8'

then the issus fixed.

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8337095/viewspace-1039630/,如需轉載,請註明出處,否則將追究法律責任。

相關文章