SQL Server Express 2008 supports database backups. It's missing SQL Agent, which allows to schedule backups, and the maintenance plan wizard for creating a backup tasks.
You can backup databases in two different ways:
1.Use Microsoft SQL Server Management Studio Express which has the Backup option on the right click menu for each database under "tasks."
2.Use T-SQL to manually write your backup script. Read the MSDN documentation for the T-SQL BACKUP command.
If you want to schedule your backup jobs, you have to write a T-SQL script and then use the Windows Task Schedule to call SQLCmd to run the script on what every schedule you're interested in:
sqlcmd -i C:\SqlJobs\backup.sql -o C:\Logs\output.txt
Source :
http://serverfault.com/questions/4542/sql-server-2008-express-best-backup-solution
