Using ExpressMaint to Backup SQL Server Express 2005 Databases

You can automatically back up all user databases in your SQL Server Express 2005 install using either a stored procedure or command line program combined with windows task scheduler. ExpressMaint was written to bring some of the backup functionality from SQL Server 2000 to SQL Server Express 2005 and seems to be pretty easy to use based on the instructions at sqldbatips.com.

Combining regular backups using ExpressMaint with some shadow copying of the data files provides a fair bit of redundacy in the event of hardware failure, database corruption etc..