actually no Maintenace Plan Wizard is available for MSDE... I'd go for
standard SQL Server Agent managed jobs...
more... Maintenace Plan suffer from many headake "features" :)
Yoyako wrote:
> Thank you for you reply.
>
> I want to make a "Dtabase Maintenance Plan" for our MSDE data base.
>
> However I could not to complete the this plan. Because there is no
> infomation of "Remove files older than:" and "Bckup files extention"
> in Database Maintenance Plan Wizard.
>
> Is it difficult to use "Dtabase Maintenance Plan" in SQL Enterprise
> Mgr to create "Database maintenance Plan?
>
> Yoyako
>
> "Andrea Montanari" wrote:
>
>> hi,
>> Yoyako wrote:
>>> I tried to create "Database Maintenance Plan" for MSDE server by
>>> Enterprise Manager. However I could not set complete backup tag.
>>> (see attachment)
>>>
>>> Please give me advice to fix this. I want to take a back up
>>> correctry.
>>>
>>> Yoyako.
>>
>> please excuse my poor english, but I was not able to understand your
>> needs.. --
>> Andrea Montanari (Microsoft MVP - SQL Server)
>>
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org >> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
>> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a
>> visual interface)
>> --------- remove DMO to reply