Hi Sourav Mukherjee,

You can use the below command.

ALTER DATABASE [mydb] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

RESTORE DATABASE [mydb] FROM DISK='f:\backup\mydb.bak'

GO