Maintenance Plan folder not shown in Management Folder

Hi,
I have a problem on just one server : The Management folder in
Enterprise Manager does not contain a folder for Maintenance plans. I
have created a plan by right clicking on a db, all tasks > maintenance
plan, but I have no way of editing this as it is not displayed
anywhere. I know I can edit the individual jobs that appear in the
Jobs folder, but I'd like to know why the maintenance plan folder is
not shown. It's not possible to re-install SQL, I would appreciate any
help.
Thanks
Kev.Perhaps just a refresh problem? Have you tried to restart Enterprise Manager
?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"kev smart" <kev@.earlshilton.com> wrote in message
news:13f1d9b4.0504040344.640c89ad@.posting.google.com...
> Hi,
> I have a problem on just one server : The Management folder in
> Enterprise Manager does not contain a folder for Maintenance plans. I
> have created a plan by right clicking on a db, all tasks > maintenance
> plan, but I have no way of editing this as it is not displayed
> anywhere. I know I can edit the individual jobs that appear in the
> Jobs folder, but I'd like to know why the maintenance plan folder is
> not shown. It's not possible to re-install SQL, I would appreciate any
> help.
> Thanks
> Kev.|||Yes, restarted em. Now I find out its SQL 2000 msde with no SP, am I
right in thinking that the maintenance plan option should be added when
applying sp3a?
Thanks
Kev|||I'm not sure, I haven't used EM against MSDE. Give it a spin and see...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"nsiadmin" <kev@.earlshilton.com> wrote in message
news:1112621866.677876.74970@.l41g2000cwc.googlegroups.com...
> Yes, restarted em. Now I find out its SQL 2000 msde with no SP, am I
> right in thinking that the maintenance plan option should be added when
> applying sp3a?
> Thanks
> Kev
>|||I applied sp3adesk, wrote output to a log file which ends with
(snip)
Property(C): DATABASE = C:\DOCUME~1\NETWOR~1\LOCALS~1\Temp\6c801
f.msi
Property(C): OriginalDatabase = D:\sql2ksp3\MSDE\Setup\SqlRun01.msi
Property(C): UILevel = 3
Property(C): QFEUpgrade = 1
Property(C): Preselected = 1
Property(C): ACTION = INSTALL
=== Logging stopped: 4/5/2005 7:18:49 ===
MSI (c) (C4:CC): Note: 1: 1728
MSI (c) (C4:CC): Product: Microsoft SQL Server Desktop Engine --
Configuration completed successfully.
MSI (c) (C4:CC): Grabbed execution mutex.
MSI (c) (C4:CC): Cleaning up uninstalled install packages, if any exist
MSI (c) (C4:CC): MainEngineThread is returning 0
=== Verbose logging stopped: 4/5/2005 7:18:49 ===
Which looks like a successful install, but after rebooting the server and
going back into enterprise manager, there is still no Maintenance Plan folde
r
and the server properties ( and @.@.version ) show the version as sql2000
8.00.194 RTM as though no service pack installed.
Getting desperate....... Kev.
"Tibor Karaszi" wrote:

> I'm not sure, I haven't used EM against MSDE. Give it a spin and see...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "nsiadmin" <kev@.earlshilton.com> wrote in message
> news:1112621866.677876.74970@.l41g2000cwc.googlegroups.com...
>
>|||Have you checked whether the maint wiz is included in msde? I'm not sure it
is...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"kevsmart" <kevsmart@.discussions.microsoft.com> wrote in message
news:711B7170-7B9F-4570-B40B-8023EECD1A56@.microsoft.com...[vbcol=seagreen]
>I applied sp3adesk, wrote output to a log file which ends with
> (snip)
> Property(C): DATABASE = C:\DOCUME~1\NETWOR~1\LOCALS~1\Temp\6c801
f.msi
> Property(C): OriginalDatabase = D:\sql2ksp3\MSDE\Setup\SqlRun01.msi
> Property(C): UILevel = 3
> Property(C): QFEUpgrade = 1
> Property(C): Preselected = 1
> Property(C): ACTION = INSTALL
> === Logging stopped: 4/5/2005 7:18:49 ===
> MSI (c) (C4:CC): Note: 1: 1728
> MSI (c) (C4:CC): Product: Microsoft SQL Server Desktop Engine --
> Configuration completed successfully.
> MSI (c) (C4:CC): Grabbed execution mutex.
> MSI (c) (C4:CC): Cleaning up uninstalled install packages, if any exist
> MSI (c) (C4:CC): MainEngineThread is returning 0
> === Verbose logging stopped: 4/5/2005 7:18:49 ===
>
> Which looks like a successful install, but after rebooting the server and
> going back into enterprise manager, there is still no Maintenance Plan fol
der
> and the server properties ( and @.@.version ) show the version as sql2000
> 8.00.194 RTM as though no service pack installed.
>
> Getting desperate....... Kev.
>
> "Tibor Karaszi" wrote:
>|||The wizard is there because it is accessible by right clicking the db name,
all tasks, maintenance plan. However although this creates the plan and jobs
,
it wont run because there is no sqlmaint.exe in the binn folder. Once this i
s
copied in (from any other SQL installation ) the next plan to be created wil
l
generate the Maintenance Plan folder under Management. Problem solved!
Thanks
Kev
"Tibor Karaszi" wrote:

> Have you checked whether the maint wiz is included in msde? I'm not sure i
t is...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "kevsmart" <kevsmart@.discussions.microsoft.com> wrote in message
> news:711B7170-7B9F-4570-B40B-8023EECD1A56@.microsoft.com...
>
>