Follow the steps mentioned below to restore a database from a backup file.
Open your MS SQL Server Management Studio and connect to your database.
Select the database and Right-click >> Tasks >> Restore >> Database:
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:
Select the option “Backup media as File” and click on the Add button to add the backup file location.
Select the backup file you want to restore and click the OK button:
That’s it! Now you have restored your SQL server database successfully with confirmation message “The restoration of database ‘SQLDatabaseName’ completed successfully.“.
