To restore a database operation steps

1: Right-click on Database Selection task-restore-database.

Select the source device-Select file, locate the database backup file you want to restore, click OK, execute.

If the database is in use, you cannot obtain exclusive access to the database under the error, you need to first disconnect the database connection with the corresponding SQL as follows

 UseMASTERDECLARE @i INT   SELECT   @i=1   DECLARE @sSPID VARCHAR( -) DECLAREKill_cur SCROLLCURSOR  for     SELECTSPID fromsysprocessesWHEREDBID=db_id('you want to kill the connected database name')                            OPENKill_curIF @ @CURSOR_ROWS=0 GOTOEnd_kill_curFETCHFirst fromKill_cur into @sSPID               EXEC('KILL'+@sSPID)                  while @i<@ @CURSOR_ROWS   BEGIN           FETCH NEXT  fromKill_cur into @sSPID                   EXEC('KILL'+@sSPID)       SELECT @i=@i+1   ENDend_kill_cur:CLOSEKill_curdeallocateKill_cur

After you disconnect the database and then click Execute, the restore succeeds.

To restore a database operation steps