Follow

Database Hosting - Backup Or Restore A Database

Prerequisites

Active SQL & Web services, see Add Hosted Services.

Summary

This article will demonstrate how to backup and restore a Microsoft SQL 2008 database.


1. In a web browser navigate to the ITSolutionsNow database access page:  http://sqladmin.myhostedsolution.net/
 

2. Login to the database using the process described in the Connect To A SQL Database support article.

1.png

3. Click the Tools menu.
2.png

4. Click Backup Wizard (Web Hosting).
3.png

5. Specify the following information:

  • Database: The database to be backed up
  • Set Name: Name for the backup set.
  • Set Description: Details of the backup setup.

Once entered click the Backup button.
4.png

6. After the backup completes, a link will be displayed to allow local download of the backup.
5.png


Restore A Database From a Backup

4. Picking up from Step 3 above, click on Restore Wizard (Web Hosting).
6.png

5. Specify which database will be restored, and then select the file to be uploaded for the restore. Once entered click Restore Database.

7.png

6. The upload will take a few moments, displaying a load window, and then the database will be restored.
8.png

 

What Is Next?

Add Hosted Services

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.