mssql restore database

SSMS => Right click destination database => Tasks => Take Offline

Find the location of database backup and latest full backup (BAK)

SSMS => New Query => Do restore with following script (notice: this example restore is done from prod to test)

RESTORE DATABASE SomecityTest FROM DISK='I:\SQLBackup\SomecityProd\SomecityProd_backup_2021_08_09_190001_2760309.bak'
WITH
   MOVE 'SomecityProd' TO 'F:\SQLData\SomecityTest.mdf',
   MOVE 'SomecityProd_log' TO 'G:\SQLData\SomecityTest_log.ldf',
   REPLACE

SSMS => Right click destination database => Tasks => Take Online