If you restore a database WITH NORECOVERY option, the database will stay in Restoring state so you can restore additional backups:
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;