Groups | Blog | Home
all groups > sql server msde > april 2005 >

sql server msde : I could not set complete backup tag.


Yoyako
4/22/2005 5:29:45 PM
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.

Andrea Montanari
4/23/2005 5:05:58 PM
hi,
[quoted text, click to view]

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

Yoyako
4/29/2005 12:12:05 PM
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

[quoted text, click to view]
Andrea Montanari
5/3/2005 12:00:00 AM
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.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

[quoted text, click to view]

Yoyako
5/3/2005 4:26:02 PM
Thank you for your quick response.

I will convert from MSDE to SQL next year.

[quoted text, click to view]
AddThis Social Bookmark Button