Knowledgebase: MSSQL Server
How do I restore MS SQL database from a backup (Plesk)
Posted by Sean Syed on 18 February 2013 06:30 PM

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

  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.

  2. 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.

 

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.

  3. Select the Restore database from backup file check box.
  4. 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.
  5. Provide the default username and password for the restored database.
  6. Click OK.
(2 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).