We are excited to spotlight an application that allows our shared hosting users to easily backup and restore Microsoft SQL Server 2000, 2005, and 2008 databases in real time. (Although our shared hosting services already include free automatic nightly backups of MS SQL databases, these backups are archived internally and accessible only via our customer support department).
By using this web based tool (accessible via our control panel), shared hosting customers are able to generate a real-time backup from any MS SQL database server and download it instantly as a .bak file to their local environment. The solution also allows our shared hosting customers to upload real time changes to their databases – for example, developers who are working in a local environment can use this tool to upload local changes to the database instantly.
If you are making changes remotely to your live database, the tool also allows you to make a backup and have it ready to restore in case you need to roll back changes.