- Select the database and then right-click on the database, select Tasks > Restore > Database, which will open the Restore Database dialog box
![](https://mushaaf.net/wp-content/uploads/2021/12/image-51.png)
2. Double click on the “Device”.
![](https://mushaaf.net/wp-content/uploads/2021/12/image-52.png)
3. Click on the “Add” to add backup in the database.
![](https://mushaaf.net/wp-content/uploads/2021/12/image-53.png)
4. Select the backup and then click on OK.
![](https://mushaaf.net/wp-content/uploads/2021/12/image-54.png)
5. Click on “Files” and then select the “RelocateAll files to folder”.
![](https://mushaaf.net/wp-content/uploads/2021/12/image-55.png)
6. Click on Options and then select the “Overwrite the existing database”.
![](https://mushaaf.net/wp-content/uploads/2021/12/image-56.png)
Now you successfully restored the database.