Deployment - Sql Server Database Backup

Using the Hosting Control Center, you can backup and restore SQL Server databases as often as you would like. However, you can only initiate a backup after any previous backup or restore request has completed.

When you create a back-up file using the Hosting Control Center, our system names the file using the name of the existing database. However, while you cannot define a filename during the back-up process, you can rename a file once the process is complete.

Note: You must use the .bak filename extension when renaming any SQL Server back-up file.

You cannot restore MS SQL 2005 backups into an MS SQL 2008 database at this time.

To Back Up SQL Server Databases

1. Log in to your Account Manager.
2. From the Products section, click Web Hosting.
3. Next to the hosting account you want to use, click Launch.
4. In the Databases section of the Hosting Control Center, Click the SQL Server icon.
5. Click the pencil icon next to the database you would like to back up to open its edit features.
6. Click the Backup icon in the menu bar.
7. Click OK to backup your database.

Your selected database will backed up. You may check on the status of the backup progress from the SQL Server database information screen in the Hosting Control Center at any time.