Hey guys, I need to acomplish the following. i've made a small application with a MDF Db. I want to upload that to a server using FTP.

(I have the FTP code, and the upload rready). But I want it to run every 7 days.

Do I work with the task scheduler? and if so, are there any code samples?

unrelated question: What type of SQL server do i need to install for MDF. Is it a compact sql server? sql server express? or sql servr 2005. (i think its 2005)
thanks