Backing Up a SQL Server Database
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.
To Back Up a SQL Server Database
- Log in to your Account Manager.
- In the My Products section, select Hosting.
- Click Manage Account next to the hosting account you want to modify.
- In the Databases section of the Hosting Control Center, Click the SQL Server icon.
- Click the pencil icon next to the database you would like to back up to open its edit features.
- Click the Backup icon in the menu bar.
- 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.
For additional information about backing up and restoring your database, see the following articles:
Restoring a SQL Server Database
What is the difference between a system backup and a user backup?
Where are database back-up files saved?
