I was wondering if anyone who uses the shared MS SQL database solution could shed some light on what is the process in order to migrate an existing MS SQL database with all its tables, views, stored procerdures and of course data which I have on my server to the shared MS SQL service? Do we just do this through EM?

And if ever we needed to restore the DB from a backup or move it, how would have access to the .BAK file? I am assuming we can do all this through EM as long as it is installed on the web server itself but I was wondering what sort of control we would have when determinging where the backup files are located and how often the db is backedup?

Theoart,

This is a late reply, but with our Shared MSSQL solution, the user login provided has database ownership permission on your provided database. You should be able to perform any migration tasks through Enterprise Manager. As for accessing the database backups, we take backups of the databases every night around 2AM Central time, and we keep 7 days of database backups. If you ever need access to one of your backup files that exists within the retention period, just open a ticket requesting this. From there, we will retrieve the backup file, ZIP it up, and attach it to the ticket for you. Hope this anwsers your questions!