How to restore Database from Database Backup File in SQL Server

Open SQL Server Management Studio (SSMS)

Connect to the server.

Right click on 'Databases'. Following menu will appear.

Click 'Restore Database'. Following window will appear.

In Source, select 'Device' radio button and click button. Following window will appear.

Click 'Add'. Following window will appear.

Locate your backup file and select it from 'Locate backup file' window and click 'OK'.

You will be navigated back to 'Select backup devices' window. Click 'Add'.

Once your backup file is successfully loaded in the 'Backup sets to restore', click 'OK'. The restoration can take up to a few minutes depending on your file/database size.

On the database has been restored, click 'OK'. The window will close and restored database will appear in the list of databases (refresh if needed).