Automating the Backup of SQL Server Express 2005 and 2008

A great article with a tool you can use to automate backups of SQL Server 2005 and 2008 Express databases from the command prompt.

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

The ExpressMaint utility supports the following operations

• Full Database Backup
• Differential Database Backup
• Log Backup
• Housekeeping of backup files
• Database Integrity Checks
• Database Index Rebuilds
• Database Index Reorganization
• Database Statistics Update
• Report Creation