How can I auto-backup a SQL Server Express database?

I've deployed MS Sql Server Express edition on a server with a database that's updated daily. It is important that I have regular backups of the database, preferably daily. But I can't hope to do this manually everyday. How can I have auto-backups of my databases on that server? A system that will preferably upload these databases to a FTP location.

Do you know of any tool that does that?

Or is there any script that I can write to create backups. I can then use a tool like Cobian Backup to automatically upload these backups to a remote location.

Thanks for your help.

From stackoverflow

• The first answer is to use sql standard instead of express. However, given that it requires an outlay of cash you can look at the following article on sqldbatips.com

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

  It's purpose is to show you how to create a simple tool for performing back ups. From there it's just a simple skip to uploading it to an ftp site.

  EDIT: I just found this. http://sqlbackupandftp.com/ the domain name says it all.

  Cyril Gupta : I had a quick look and this looks like what I wanted. Thanks Chris. Yes, I can't afford SQL Server. You know what, I am planning to eventually migrate to Mysql or PostGres :).

• I would take a look at a blog entry I wrote on the subject. It explains exactly how to backup SQL Server Express databases.

  http://gatekiller.co.uk/Post/Automate_SQL_Server_Express_Backups

  I would then, like you mentioned, use another tool to upload these backups to an FTP site.

  If your thinking about moving to an open source database, I would suggest moving sooner rather than later. Integrating MySql with Microsoft technologies is easier than you think with the MySqlClient library.

  http://dev.mysql.com/doc/refman/5.0/en/connector-net.html

  Cyril Gupta : Excellent links. Thanks!

  Cyril Gupta : Yes Gatekiller, I've been putting it off. The reason is that many of my queries have ROWCOUNT and other Transact SQL constructs and I will have to re-write them in SQL. But I must do it soon.

  Rob : It's worth mentioning (the voice of painful experience here! =) that the MySql Connector is nowhere near as robust as the Sql Server one, although it has improved in the last few releases. Also, depending on how complex your queries are and data volumes, MySql can sometimes be harder to code for as the optimiser isn't as mature as Sql Servers.