2005 Express Maintenance

[MasterRacker]

Came across this for emulating maintenance plans on 2005 Express:

http://www.sqldbatips.com/showarticle.asp?ID=29

It looks like I can do pretty much anything I want. Just wondering what other approaches other might be using to automate maintenance of Express servers.

(I have some commercial apps that use Express and I am not free to migrate the DBs to a full SQL server.)

Jeff
[small][purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me[/small]

 

[mrdenny]

Without knowing exactly what those apps are doing, can't say for sure. They are probably better than not doing anything. You'll need to use Task Scheduled to run them as the SQL Express doesn't have a scheduler any more.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[MasterRacker]

Yeah, they mentioned the task scheduler. I haven't looked at the SQL code, but it looks like he created a SMO to replicate the same tasks that are available in the Maintenance plan wizard.

Jeff
[small][purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me[/small]