Hi ,
Please find details below, how to restore backup using SSMS
Restore an earlier disk backup with a new database name where the original database still exists
In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.
Right-click Databases and select Restore Database...
On the General page, select Device under the Source section.
Select the browse (...) button to open the Select backup devices dialog box. Select Add and navigate to your backup. Select OK after you've selected your disk backup file(s).
Select OK to return to the General page.
- In the Destination section, the Database box is automatically populated with the name of the database to be restored. To change the name of the database, enter the new name in the Database box.
Select Options in the Select a page pane.
- Under the Tail-log backup section, uncheck "Take tail-log backup before restore".
reference document-
Hope this helps!
Let us know if you need any additional information.