Currently, I am hosting my mojo on a server where I have no access. I have to email the administrator if I have any requests for changes. I basically have a user account to my SQL database and I have FTP access to the folders.

With that in mind, what about building an admin feature that would backup my database and copy my portal site into a compressed folder of my choosing? I'm thinking it would be necessary for this to be queued process so it doesn't stop the responsiveness of the web site.

Do you have anything written up as to the process of backing up for those of us less qualified to mess with SQL Server? Your installation documents were great by the way!

Hi there,

Side tracking a bit, but have you seen this ms tool, I used it the other day, as i wanted to update my db online without having to request admin support.

It generates a single SQL script file which can be used to recreate a database (both schema and data) in a shared hosting environment where the only connectivity to a server is through a web-based control panel with a script execution window.

http://www.microsoft.com/downloadS/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

Might be of some interest