MilesWeb Hosting Forum

Web Hosting Technical Support => How To's => Topic started by: Rahul Sambre on July 27, 2016, 02:22:39 AM

Title: How to restore MSSQL database from SQL server management studio?
Post by: Rahul Sambre on July 27, 2016, 02:22:39 AM
Hello,

Follow below steps to restore MSSQL database from SQL server management studio.

Quote
1) Login into your server [VPS/managed dedicated server India (https://www.milesweb.com/dedicated-servers.php)] by accessing remote desktop connection.

2) Click on SQL Server Management Studio.

3) Fill the details as below to connect to SQL Server Management Studio.

4) Expand the Databases option. Right click on the database name, which you want to restore, Go to Tasks >> Restore >> Database.

5) Click on Options from the left pane. Then select these options.
  • Under Restore options section, check the option Override the existing database (WITH REPLACE).

6) Now, select the option General from the left pane. Then select these options.
  • Under Destination for restore section, select your database from the drop down list of To database.
  • Under Source for restore section, select the From device option.

7) Select the button beside From device option then keep the Backup media type as File and click on Add button.

8 ) Now, select the path of the backup file of your database.

9) After selecting the file, click on OK button in order to restore the database.

That's it.   :)