Most of the people facing an issue stuck database in restoring mode, after successful restore of the database. Why this is happening ? This is likely caused by WITH No RECOVERY, missing of adding with recovery option will causing the issue.
This is the situation database is looking for latest transaction log after restoring.
To resolve this issue restore the database again is a time consuming thing, So we can force the database out of restoring mode by executing below script.
RESTORE DATABASE YourDbName WITH RECOVERY
ALTER DATABASE YourDbName SET ONLINE