How to Restore MS SQL Database from Backup

In today's article I will show an example how you can restore your (.bak) taken backup file again to the new MS SQL server data base. So for this tutorial we will connect to our MS SQL database server.

After connecting to the SQL server, we need to create a blank database. This blank database we will use for restoring the backup file. So here is our backup file which we will restore.

Now let's check the newly created blank MS SQL server database.

Now restore the .bak filer we need to right click on database named as Emp and select Task option.

On selection on Task a Right menu will open. From this menu we will we need to select option "Restore". Ones you select option Restore you will again get a new menu option. From this option select "Database".

Ones we click on "Database" below mention screen will open.

So here we are having two option first option is "Database" and second is "Device". So here the first option which is "Database" will use to select the database which we wat to restore in the blank newly created database. The second option "Device" will allow us to select the .bak file. So, we will go with second option "Device".

Device: This option we need to locate the .bak file which we want to restore. To select the backup file click on "...". Ones you click a window will open.

Here I have already selected a backup file. By clicking on "Add" button. Ones you click on "Add" button a window will open. From this window we need to select the .bak file.

After selecting the backup file we need to click on "Ok" button. Ones we click on "Ok" button.

Above screen looks after adding a backup file.

Now from top left menu we need to select "Options". Here you need to selection option Overwrite the existing database (WITH REPLACE) and second option is to "Close existing connection to designation database".