Follow the steps mentioned below to restore a database from a backup file.

STEP 1: Open your MS SQL Server Management Studio and connect to your database.

STEP 2: Select the database and Right-click >> Tasks >> Restore >> Database:

STEP1

STEP 3:  The “Restore Database” window will display. Select “From device” mentioned below the “Source for restore” and click the button in front of that to specify the file location:

STEP2

STEP 4: Select the option “Backup media as File” and click on the Add button to add the backup file location.

STEP3

STEP 5: Select the backup file you want to restore and click the OK button:

STEP4

That’s it!  Now you have restored your SQL server database successfully with confirmation message “The restoration of database ‘SQLDatabaseName’ completed successfully.“.