RESTORE DATABASE throgh Command

USE master

GO

RESTORE FILELISTONLY

FROM DISK = 'C:\Inetpub\wwwroot\IHMS.WEB\IHMS.bak'

GO

RESTORE DATABASE IHMS

FROM DISK = 'C:\Inetpub\wwwroot\IHMS.WEB\IHMS.bak'

WITH MOVE 'IHMS' TO 'C:\Inetpub\wwwroot\IHMS.WEB\IHMS.mdf',

MOVE 'IHMS_log' TO 'C:\Inetpub\wwwroot\IHMS.WEB\IHMS_log.ldf'

GO

ALTER DATABASE IHMS SET MULTI_USER

GO