I encountered an issue where a SQL Database was in restoring state after a restore operation failed from SQL Management studio UI.

I used the following SQL Script to take the database back to operational state:

Script:

RESTORE DATABASE [Database Name]
WITH RECOVERY