SQL Server Express: maintenance plan

[Thomas]

I use SQL Server Express 2005 SP2.(Microsoft SQL Server 2005 - 9.00.3042.00)
I want to make a maintenance plan, but I don't have a task called
"maintenance plan"
I am user sa with "sysadmin"
How can I make a maintenance plan.
Thanks for your help
Thomas

[Andrea Montanari]

hi,

Post by Thomas
I use SQL Server Express 2005 SP2.(Microsoft SQL Server 2005 -
9.00.3042.00) I want to make a maintenance plan, but I don't have a
task called "maintenance plan"
I am user sa with "sysadmin"
How can I make a maintenance plan.
Thanks for your help
Thomas

SQLExpress does not include the SQL Server Agent (as MSDE did) nor the
"maintenance plan" feature (as MSDE did not provide as well)..
so you have to use the native OS scheduler to schedule the task you like as
BACKUP DATABASE... and the like.. please have a look at
http://www.sqldbatips.com/showarticle.asp?ID=27 and
http://www.sqldbatips.com/showarticle.asp?ID=29 for an alternate solution
based on the native OS scheduler..

[Thomas]

Thank you,
perfect.

Thomas