One of the things that I really missed with the move from SQL Server 2000 Desktop Edition to SQL Server Express 2005 was the removal of the SQL Server Agent and the Database Maintenance Plans.

I’ve gotten over the removal of SQL Server Agent by simply using Scheduled Tasks. You can simply save what your TSQL script into a file, then create a Scheduled Task in Windows in teh format:

"C:\Program Files\Microsoft SQL Server\90\Tools\Bin\SQLCMD.EXE" -S .\SQLEXPRESS -i"C:\myscript.sql"

What I really missed, though, was the Database Maintenance Plans. Recently, I found the answer — a great project created by Jasper Smith (sqldbatips.com) called ExpressMaint. The utility is available in both a command-line utility (great for Scheduled Tasks) or a TSQL stored procedure (which you could then schedule using the method above). The project is available at:

http://www.codeplex.com/ExpressMaint

This does everything that the Database Maintenance Plans did, but easier to use in my opinion. It lets you do full backups, log backups, reindex, and check the database for integrety. It even has nice features like automatically deleting logs or backups older than x days.