This article will guide you on how to restore MSSQL database from SQL Server Management Studio.
- Login into your server [Windows VPS/Dedicated Server] by accessing remote desktop connection.
- Click on SQL Server Management Studio.
- Fill the details as below to connect to SQL Server Management Studio:
- Server Type: Database Engine
- Server name: IP address,1533
- Authentication: SQL Server Authentication
- Login: Database username
- Password: Database user's password
- Expand the Databases option. Right click on the database name, which you want to restore e.g. ASPNETDB, go to Tasks -> Restore -> Database.
- Click on Options from the left pane. Then select these options:
- Under Restore options section, check the option Override the existing database (WITH REPLACE).
- Under Recovery state section, select Leave the database ready to use by rolling back uncommited transactions. Additional transaction logs cannot be restored (RESTORE WITH RECOVERY).
- 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.
- Select the button beside From device option then keep the Backup media type as File and click on Add button.
- Now, select the path of the backup file of your database.
- After selecting the file, click on OK button in order to restore the database.
