Step 1: Open your Microsoft SQL Server Management Studio Express and connect to your database.
Step 2: Select the database >> Right-click >> Tasks >> Restore >> Database [as shown in the image below
Selecting Options within Restore Database dialog box.
Specifying correct path to the mdf and log file for the database.
Checking Overwrite the existing database option.
