It's possible to create a maintenance plan with Enterprise manager

It's possible to create a maintenance plan with Enterprise manager in my MSDE
db?
When I try to create a "maintenance plan" I have blank menu (for example
"Use this directory" or "remove files older than" or "backup file extension"
).
Any help will be appreciated.
Thanks
hi Andrea,
andrea favero wrote:
> It's possible to create a maintenance plan with Enterprise manager in
> my MSDE db?
> When I try to create a "maintenance plan" I have blank menu (for
> example "Use this directory" or "remove files older than" or "backup
> file extension" ).
> Any help will be appreciated.
> Thanks
yes it is... the produced maintenance plan will result in a number of jobs
scheduled using SQL Server Agent scheduler...
at schedule occuring, the Job will execute the included job step(s) calling
the maintenance plan runtime and it will be processed...
the properties you are specifying regard "where do you want the backup file
to be stored", so you have to provide the full path of the database backups
browsing (or typing) the actual folder from the SQL Server OS point of
view..
"remove files older than" specifies to delete old backups (older then N
minutes/hours/days/etc :D), but probably a missing piece in MSDE package
does not fill those properties automatically (and you wont be able to set
this manually)
"backup file extension" means what the default extension will be for the
created physical files... again, probably a missing piece in MSDE package
does not fill those properties automatically..
you could probably go on and later manually edit the job step, where a call
to xp_sqlmaint is performed in the way
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
4BDC174A-0C83-4B10-9054-D7388950FF8F -Rpt "C:\Programmi\Microsoft SQL
Server\MSSQL\LOG\DB Maintenance
Plan14.txt" -WriteHistory -VrfyBackup -BkUpMedia
ISK -BkUpDB -UseDefDir -DelBkUps 0 -BkExt "bak"'
and so modifying the -DelBkUps 0 in
-DelBkUps 1days or whatever... but you have to manually dig in the sqlmaint
parameter list
(http://msdn.microsoft.com/library/de...maint_19ix.asp)
personally I do not like SQL Server 7.0 and 2000 maintenance plan utility
and I strongly prefer writing my job by hand specifying the actual
statements that will be perfomed instead of assuming the black box (and
buggy) of maintenance plan will do what I expect to be done...
SQL Server 2005 modified that behavior, but SQLExpress is not provided with
the maintenance plan runtime and with the SQLServer Agent anymore, thus you
have to resort on third party (or home made) scheduler or on the native OS
AT scheduler like in http://www.sqldbatips.com/showarticle.asp?ID=29
BTW, as MSDE usuer, you are not likely supposed to legally interact with it
via Enterprise Manager or Query Analyzer..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply