The SQL Server backup and restore component provides an essential safeguard for protecting critical data stored in your SQL Server databases. To minimize the risk of catastrophic data loss, you need to back up your databases to preserve modifications to your data on a regular basis. A well-planned backup and restore strategy helps protect databases against data loss caused by a variety of failures. Test your strategy by restoring a set of backups and then recovering your database to prepare you to respond effectively to a disaster.
Open SQL Server Management Studio and login to the SQL Server you want to restore the database to. It is best to either login as a Windows Administrator or as the SQL ‘sa’ user.
Once logged in Right click on the Databases and select Restore Database
Click the button next to From device under the Source for restore to browse the location of backup file
Specify Backup location by clicking Add
Select the backup file
and click ok
Input the database Name
Go to the options Tab Check Overwrite the existing database (WITH REPLACE)