In order to restore a database from a backup file, follow the steps shown below:
Open your Microsoft SQL Server Management Studio and connect to your database.
Select the database >> Right-click >> Tasks >> Restore >> Database.
The following “Restore Database“ windows will appear. Select “From device” mentioned under the “Source for restore” and click the ellipses 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.
Browse the backup file (.bak) you wish to restore and hit the OK button.
Select the restore point you want to use. Since a SQL backup file can hold multiple backups you may see more than one restore point listed.
Once your restore options are set, click Ok.
SQL Server Management Studio makes the restore process simple and is ideal if you seldom perform database restores. This process works in every version of SQL Server from Express to Enterprise.
By the end of this article you will know the procedure of backing up and restoring MS SQL Server Database.