database in recovery
If database suddenly went in to in recovery mode, due to less available space for transaction, you can fire below query and bring it live
ALTER DATABASE pubs
SET QUOTED_IDENTIFIER ON, RECOVERY FULL, MULTI_USER
Simple Recovery allows the database to be recovered to the most recent backup.
Full Recovery allows the database to be recovered to the point of failure.
Bulk-Logged Recovery allows bulk-logged operations.