Database stuck in “Restoring” state while restoring DB backup?

You need to use the WITH RECOVERY option, with your database RESTORE command, to bring your database online as part of the restore process.

This is of course only if you do not intend to restore any transaction log backups, i.e. you only wish to restore a database backup and then be able to access the database.

Here is the Syntax / Command to restore Database with recovery:

RESTORE DATABASE SampleDBName FROM DISK = "C:\DB_Backups\DB123.bak'

WITH RECOVERY

GO