Hello friends. Today we are going to learn how we can restore a database back up using management studio in SQL Server. It is quite easy to restore a database backup using management studio, just follow me with the steps that I am going to take.
As you can see in the below image, Management studio is already opened on my computer, to store a database back, I will right click on the “databases” folder and navigate through the menu options shown in the below image.
Now click on “Restore Database” menu, that will bring up a new screen as shown in the below image.
On the above screen, we need to provide a name to the database that is being restored, I have given name “Mydatabase” in the text field which is encircled with red color. As you can see in the above image a red color arrow is indicating to select the “From Device” radio button (we are doing this because we are not restoring database from a database, we are restoring database from a backup file).
Now, we need to provide the path of the database backup that is going to be restored. Hence, we will click on the button(encircled with red color) in the above image that will bring up a new screen as shown in the below image.
We will click on “Add” button(encircled with red color) in the above image that will further bring up a new screen as shown in the below image.
We will select “All files” option for “Files of type” in the above screen and specify the database file location and click on “OK” button. Clicking on “OK” button will close the current screen and bring us back to the earlier screen.
In the above screen, you can see that path of the database base backup file is showing in the text field.Click on “OK” button that will close the current screen and will bring us back to the below mentioned screen.
On the above screen, I have encircled “Restore” check box, that needs to be checked. Post marking the check box as checked, click on “OK” button. As soon as we click on “OK” button, database restoration process will be start and will show a message box showing the success of the restoration process.
I hope you will like this article. Please share your thoughts on this article by adding your comments.
1,651 total views, 3 views today