I could not set complete backup tag.

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.
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.shtmhttp://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
|||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:
> 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.shtmhttp://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
>
>
|||hi,
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"
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://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
Yoyako wrote:[vbcol=seagreen]
> 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:
|||Thank you for your quick response.
I will convert from MSDE to SQL next year.
"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.