Automate Backups in SQL Server Express 2005 / 2008

There is a great utility available for free that allows you to create automated full and incremental backups for SQL Express 2005 & 2008. The tool is called: ExpressMaint and can be found here:

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



It is a command line application that allows you to specify your backup settings via command line parameters. Then you can set this utility up as a scheduled task in Windows to run when you want. It uses SMO to automate SQL Server. You can find the code for this utility and the latest builds here:

http://www.codeplex.com/ExpressMaint

It has logging and backup naming by date built-in and is free to download and use.