How do I backup my SQL database? (With Instructional Video)
Article ID#:
6826
Creation Date:
Feb-26-2008
Updated Last:
Apr-29-2008

Summary: Use the SQL Server Management features to make a backup copy of your MSSQL 2005 database. This article contains a link to an instructional video.


Keywords: 6826, Windows, SQL, MSSQL, 2005, server, management, backup, database
Description: a description goes here


Note: This article describes features associated with Windows plans. Some features are not available for all accounts, and may appear differently in your Control Panel interface. If you want to use this feature but do not have it, please call sales.

To Backup Your SQL Database:

The following steps assume that you have accessed your Control Panel. For information about accessing your Control Panel, go to How do I access my Windows Hosting Control Panel?

For information and an instructional video on backing up your SQL database from your Control Panel, go to Backing Up SQL 2005 Using the Control Panel (Video and Transcript).

  1. On your Hosting Control Panel, click MSSQL Control Panel. The SQL Server Management window appears.
  2. Note: This page may take a few minutes to load. If you have not yet upgraded your MSSQL database, you are taken to the Manage SQL Database window which will allow you to perform the upgrade. You must upgrade your database in order to use these feature.

  3. Click Manage for the database you want. The Manage SQL Database window appears.
  4. Click Backup Database. The Manage SQL Database window refreshes with a confirmation message.
  5. Note: Your database request appears in the Pending Requests section if other databases on the server are being processed.

  6. Download your database backup. Delete this file from your /data directory in order to create another backup file using this interface.

Note: Use this tool for creating a backup database. Databases cannot be restored using this tool if any changes are made to it. Make changes to your database using Microsoft SQL Server Management Studio tools.

For information about importing your database using a direct connection to your remote SQL database, go to Importing Your Database Using Direct Connection.

For information about importing your database using a database file, go to Importing Your Database Using a Database File.

For information about viewing your request log, go to Viewing Your Request Log.

Back to top ^