Restore SQL Server database using Management Studio

Introduction

Here, I will explain how to restore an SQL Server database from a backup file (.bak) file using SQL Server Management Studio (SSMS)

Step 1: Open SQL Server Management Studio

 image001

Step 2: Login with your credentials

image002

Step 3: Right click on Databases node in the Object Explore and select Restore Database

Microsoft SQL Server Management Studio_2014-09-14_10-52-37

Step 4: Click on Device in the Source section and click on browse button (…) to select your backup file.

Restore Database - _2014-09-17_00-46-02

Step 5: Click on Add button to select the backup file(.bak) then click OK.

Select backup devices_2014-09-17_00-49-06

Default name of the destination database will be the same as in the backup file. You can change it in the Destination section.

Restore Database - Galaxy_2014-09-17_00-56-44

Step 6: Click on File tab, select Relocate all files to folder then select folder where you want to restore your database.

Restore Database - Galaxy_2014-09-17_19-57-10

Default location of the restored database is the data directory of the SQL Server. To change it you need to follow this step. Otherwise you can skip this step.

Step 7: Click on OK to complete restore.

Microsoft SQL Server Management Studio_2014-09-17_20-13-27

2 thoughts on “Restore SQL Server database using Management Studio

  1. ratan pandey

    thanks for that
    i want to manage time in sql
    like face book
    kitni der pahle post kiya gaya hai
    just now
    1 min ago
    yesterday
    i week ago
    like this
    please help me for this

    Reply
  2. Mark Willium

    SQL server database can be restore from bak file command line also. To do this, you need to open the command prompt and run below query. It is connect to the instance.

    C:> SQLCMD -S localhostDMSQL2012 -U sa -P sqlserver

    After successful connection, use ‘master’ and run this query to restore the database.

    restore database SQLServerDatabase from disk=’e:testSQLServerDatabase.bak’ with stats=10
    Thanks

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *