How to restore MSSQL database from SQL Server Management Studio?

This article will guide you on how to restore MSSQL database from SQL Server Management Studio.

 

  1. Login into your server [Windows VPS/Dedicated Server] by accessing remote desktop connection.

  2. Click on SQL Server Management Studio.

    Open SQL Server Management Studio


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


    Specify Details to Connect to MSSQL Server

  4. Expand the Databases option. Right click on the database name, which you want to restore e.g. ASPNETDB, go to Tasks -> Restore -> Database.

    Select Restore Option from Tasks


  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).
    • 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).

      Specify Restore Options and Recovery Stats

  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.

      Specify Source for Restore



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

    Select a Backup Media


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

    Locate a Backup File that Needs to be Restored


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

Related Articles

How to install SQL Server Reporting Service (SSRS) on MSSQL 2014 Express Edition?

SQL Server Reporting Services is used for creating, publishing, and managing reports, and...

How to Shrink Transaction Logs of Database in MS SQL?

This article will assist you to shrink/truncate the transaction logs of database in MS SQL...

How to fix "Upgrade Error - Valid Database compatibility level and successful connection rule"?

One of our Windows VPS customers wanted to upgrade SQL Server from SQL Server 2008 R2 to SQL...

How to shrink MSSQL Database?

Important Note: We don't recommend to shrink your database. You can involve your Database...

Fix - Microsoft SQL Server, error: 10053 - An established connection was aborted by the software in your host machine

One of our Windows VPS customers received following error while connecting to MS SQL server....

  • 2 Users Found This Useful

Was this answer helpful?