SQL data base in Restoring mode after successfully restored

        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