MSSQL Database stuck in restore state

USE [master]

RESTORE DATABASE [YourDatabase.Name] 
FROM  DISK = N'C:\PathToBackupFiles.bak' WITH RECOVERY

With in-memory database:

USE [master]

RESTORE DATABASE [YourDatabase.Name] 
FROM  DISK = N'C:\PathToBackupFiles.bak' WITH RECOVERY,
MOVE N'XTP' TO N'C:\MSSQL\Data\XTP'
GO