Does anyone know a low cost way to transfer a MS SQL Server database? My ISP backs up the server every day, but I would like to devise a method of getting the .mdf file in my own hands (a secondary backup). I have seen that using an MS Access project, you can create a Macro with an action something like "CopyDatabaseFile" or "Transfer DatabaseFile". However, the documentation also says that you need a copy of SQL Server on your local machine (which I don't have). Ideally, I would like to set up a scheduled task on my local machine that downloads the database once per week. The other benefit of having the database in my own hands is that I can easily switch ISPs (I assume all they would need is my mdf file?).
Maybe there's something available in Open Source?
