How to restore database backup in SQL SERVER

In this article, I am going to explain the process of  Database restoration using the SQL Server Management Studio. In this article, I will try to explain this process in a simple way so that a database developer having little knowledge of DBA can restore that database using the database backup.

For database restoration process, we need to follow the below steps:-

Step 1:- Open the SQL Sever Management Studio. For this we have to follow the following path:-

START –> All Programs –> Microsoft SQL Server 2008R2 –> Click on SQL Sever Management Studio (SSMS) –> Open the SQL Server Management Studio using Login information (Username & password or Window authentication )

Please note:- Above path can be changed depending on the Window version.

Step 2:- Once SQL Sever Management Studio is opened, opened the Object Explorer. By default it will be already opened. If it is not opened, then follow the below steps to open it.

Click on the View(Top menu) –> Click on Object Explorer.

Step 3:- Under the Databases node, select the database for Restoration and right click on it. Then choose Tasks, click on Restore and then choose the Database… as shown in the below figure. Here we choose the Company_DB as database.

Select Database for restore process

Step 4:- On the click of Database.. link,  we get the Restore Database window. In this window, we can select the database backup file, first by selecting the Device radio button and then click on the Add button, as shown in the below figure:-

Select Backup file location

Step 5:- When we click on the Add button, Locate Backup File Window is opened. On this window, we have to choose the backup file of the database as shown in the below figure.

Select Database backup file

Step 6:- When user selected the database backup file and click on the OK button, it will close the Locate Backup File window. Now on the Restore database window we can see the selected database backup file as shown in the below figure.

Selected backup file

Step 7:- When we click on the Options link, below screen will be shown

Database restoration Options
In this screen, we can see many options like overwrite the existing database and many others. We can leave this screen with default values. we usually choose the option of overwrite the existing database, but user can choose other options as per his/her requirement.

If you want to know this process and its all option in detail, you can refer below link of MSDN

Restore a Database Backup (SQL Server Management Studio)

About vivekjohari

Database Consultant with more than 11.5 years of experience in database designing & programming and DBA related activities.  Had good experience on different databases like SQL Server, MySQL & Oracle, Azure SQL &  Big Data.
This entry was posted in SQL Advanced, SQL Database Restoration, SQL Server and tagged , . Bookmark the permalink.

30 Responses to How to restore database backup in SQL SERVER

  1. Pingback: Homes For Sale in Holtsville NY

  2. Pingback: Amalfi coast tour

  3. Pingback: Pangerantoto2

  4. Pingback: Istanaimpian2

  5. Pingback: tax service in Davenport Iowa

  6. Pingback: Motorsports Entertainment

  7. Pingback: pita pit coupon code march 2019

  8. Pingback: fusionsilicon x7

  9. Pingback: Top XMR

  10. Pingback: Top Realtor Tallahassee

  11. Pingback: cheapest smm panel

  12. Pingback: บาคาร่าออนไลน์

  13. Pingback: 바카라사이트

  14. Pingback: murat fedakar dolandirici

  15. Pingback: dang ky tai khoan w88

  16. Pingback: กู้เงิน ขอนแก่น

  17. Pingback: referral code

  18. Pingback: แทงบอลออนไลน์

  19. Pingback: healthy diet

  20. Pingback: Master Grower Certification

  21. Pingback: scam

  22. Pingback: Car Crashes Compilation Russia/USA/Europe 2019 HD

  23. Pingback: nha cai uy tin fun88

  24. Pingback: laser hair removal whole face

  25. Pingback: w88

  26. Pingback: forum

  27. Pingback: scr888

  28. Pingback: cbd oil tastes like

  29. Pingback: i99 casino

  30. Pingback: Darknet

Leave a Reply