How to Recover a SQL Server Database that is in the Restoring State

If you restore a database WITH NORECOVERY option, the database will stay in Restoring state so you can restore additional backups:

database_in_restoring_state

If you want to recover the database without restoring additional backups, you can bring the database online by issuing the following command:

RESTORE DATABASE [Database_Name] WITH RECOVERY;

database_in_restoring_state_recover