MSDE Maintanence Problem

I am trying to create a maintanence plan for a MSDE database using
Enterprise Manager. Under my MSDE SQL Server/Management, Database
Maintenance Plans icon does not show up. In my three other SQL Servers (1
MSDE, 2 SQL 2000) this icon does show up. And I cannot right click the
database and choose Maintenance Plans under all tasks. I am doing this via
an Enterprise Manage remotely. When I physically view the Enterprise
Manager I can setup Maintenance Plans however the plans do not work. When I
view the properties, none of the schedule shwos up and I get an error. Is
my only choice to reinstall MSDE and Enterprise Manager? Any ideas?
Thanks
hi George,
"George" <george@.noemail.com> ha scritto nel messaggio
news:OOmpQ51bEHA.2840@.TK2MSFTNGP11.phx.gbl...
> I am trying to create a maintanence plan for a MSDE database using
> Enterprise Manager. Under my MSDE SQL Server/Management, Database
> Maintenance Plans icon does not show up. In my three other SQL Servers (1
> MSDE, 2 SQL 2000) this icon does show up. And I cannot right click the
> database and choose Maintenance Plans under all tasks. I am doing this via
> an Enterprise Manage remotely. When I physically view the Enterprise
> Manager I can setup Maintenance Plans however the plans do not work. When
I
> view the properties, none of the schedule shwos up and I get an error. Is
> my only choice to reinstall MSDE and Enterprise Manager? Any ideas?
> Thanks
>
that's weird... never heard about :-(
but, FWIW, you are not allowed to manage MSDE instance with the regular SQL
Server client tools like Enterprise Manager and/or Query Analyzer...
you shoul'd resort on third party tools..
a list of some tools can be found at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Why can't I use Enterprise Manager to manage a MSDE Instance? I do have
licenses for SQL Server.
Thanks
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2m81boFjj6hjU1@.uni-berlin.de...[vbcol=seagreen]
> hi George,
> "George" <george@.noemail.com> ha scritto nel messaggio
> news:OOmpQ51bEHA.2840@.TK2MSFTNGP11.phx.gbl...
(1[vbcol=seagreen]
via[vbcol=seagreen]
When[vbcol=seagreen]
> I
Is
> that's weird... never heard about :-(
> but, FWIW, you are not allowed to manage MSDE instance with the regular
SQL
> Server client tools like Enterprise Manager and/or Query Analyzer...
> you shoul'd resort on third party tools..
> a list of some tools can be found at
> http://www.microsoft.com/sql/msde/partners/default.asp and/or
> http://www.aspfaq.com/show.asp?id=2442
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi George,
"George" <george@.noemail.com> ha scritto nel messaggio
news:Od%23dg7$bEHA.384@.TK2MSFTNGP10.phx.gbl...
> Why can't I use Enterprise Manager to manage a MSDE Instance? I do have
> licenses for SQL Server.
there's an open thread about it in Microsoft it self =;-D
a little extract of such a "flame" is a position by a Microsoft
representative like
"...
The tricky part here is the bit about using MSDE in conjunction with a
properly licensed copy of SQL Server 2000 and the fact that we don't go
into detail about exactly what that means. XXXX (name) has stated many times
in
the private SQL MVP newsgroup that that requires a bunch of lawyers and
a white board. It's almost never the case. In my opinion, we simply need
to tell folks that right now you cannot do it with MS tools at them
moment, here's a bunch of 3rd-party tools you can look at, and we'll be
providing tools with SQL Express and here's how you get a sneak preview
of that...
..."
dev/test environments can be managed with SQL Server Dev edition at will, as
test requires MSDE management too, but production enviroments seem not to be
legitimated...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply