Cannot find folder "Maintenance Plans".
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 解決cannot find module providing package或cannot find main modulePackageAI
- /usr/bin/ld: cannot find -lopenblas
- MapStruct-plus cannot find converter fromStruct
- Cannot find package module sap/cds/commonPackage
- Error: Cannot find configuration directory: /etc/hadoopErrorHadoop
- 遇到的cannot find module 'xxx' 問題
- Vue Router Cannot find module 'XXX.vue'Vue
- cannot find trajectory file at ./examples/trajectory.txt
- 解決Cannot find module '@angular/compiler-cli'AngularCompile
- SQL2012報錯:cannot find one or more cpmponentsSQL
- Go cannot find package "go-sql-driver/mysql" in any ofGoPackageMySql
- Cannot find module ‘webpack-cli/bin/config-yargs‘Web
- vue Cannot find module @/xxx/xxx.ts or its corresponding typeVue
- OPatch cannot find a valid oraInst.loc file to locate Central InventoryAI
- Cannot find a valid baseurl for repo: base/7/x86_64
- 關於/usr/bin/ld: cannot find -lXX的問題
- Cannot resolve com.demo.common:1.0-SNAPSHOTble to find main classAI
- 2.3.3 Application MaintenanceAPPAINaN
- Vue啟動報錯 Cannot find module 'webpack/bin/config-yargs'VueWeb
- 2.3.3.1 About Application MaintenanceAPPAINaN
- (轉載)關於usr/bin/ld: cannot find -lxxx問題總結
- 備忘錄:SQL SERVER2014 出現:“Cannot find one or more components”SQLServer
- 開啟 Word 文件報錯: Cannot find the Word document template:WordToRgm.dot
- Cannot find a C++ compiler that supports both C++11 and the specified C++ flags.C++Compile
- All mirror URLs are not using ftp, http[s] or file. Cannot find a valid baseurl for repo: baseFTPHTTP
- three predefined automated maintenance tasksAINaN
- CentOS7中使用yum安裝時報cannot find a valid baseurl for repo錯誤CentOS
- Error: Cannot find module ‘D:SoftSetupLoaction odejs ode_global ode_modules pmin pm-cli.js‘ErrorJS
- webstorm vue3+ts報錯:Cannot find module ‘@/views/xxx.vue‘ or its corresponding type declarationsWebORMVueView
- Linux: Centos7 Cannot find a valid baseurl for repo: base/7/x86_64 解決方案LinuxCentOS
- zabbix_maintenance web管理系統AINaNWeb
- PostgreSQL DBA(170) - pgAdmin(Queries For Index Maintenance)SQLIndexAINaN
- [!] Attempt to read non existent folder `***********`
- 完美解決SqlServer2012啟動報錯(cannot find one or more components.Please reinstall the application。)SQLServerAPP
- win10執行絕地求生時提示cannot find msvcp140.dll怎麼修復Win10
- 個性化Folder Icon(Delphi)
- [20190920]Asynchronous Global Index Maintenance and Recycle Bin.txtIndexAINaN
- 備份時報no channel allocated for maintenance(of an appropriate type)AINaNAPP
- Jenkins restriction as of credentials and user group --- Folder solutionJenkinsREST