Restoring MS SQL Database from a backup

Suggest Edits

If the database already exists

If the database already exists and you only need to restore its content:

  1. Go to Domains > domain name > Backup Manager > Database Backup Repository, select the required backup file from the list and click Restore Selected.

If you do not have the backup file on your server, you can upload the backup file to the server repository from your local machine.

For more information, refer to the section Uploading Database Backup Files to Server (below). 

  1. Confirm the restoration by selecting the corresponding check box and click OK.

If you are restoring MS SQL database, there is a possibility that some database users will be orphaned. In order to provide the ability to access and use the database for these users, you need to repair them.

Uploading Database Backup Files To Server:

To upload a backup file to backup repository:

  1. Go to Domains > domain name > Backup Manager > Database Backup Repository and click Upload Backup File.

  2. Select the database in which repository you want to upload the backup file to in the Database name menu. 

  3. Click Browse... and select the required backup file.

  4. Leave the Restore database backup immediately upon uploading check box selected if you want the database contents to be restored immediately after the backup file is uploaded.

  5. Click OK.

The database backup file will be uploaded to the backup repository of the specified database.

If the database does not exist

If the database does not exist and you need to recreate it from scratch:

  1. Go to Domains > domain name > Databases and click Add New Database.

  2. Specify the database name, type and server for the database you are restoring.

Note. You can specify a new database name, but you must choose the correct database type: for example, if you are trying to restore a MySQL database, choose MySQL database type.

  1. Select the Restore database from backup file check box.

  2. Specify the location of the database backup file.

You can upload a backup file from your local machine or specify a file located on the server.

  1. Provide the default username and password for the restored database.

  2. Click OK.

If you are restoring MS SQL database, there is a possibility that some database users will be orphaned. In order to provide the ability to access and use the database for these users, you need to repair them.

Updated 4 months ago