Problem:
A SQL database goes into recovery mode when SQL Server starts up the database. However, there maybe be instances where the ksubscibers database continues to run on Recovery Mode although the SQL logs show that the database is up and running.
Cause:
This can be caused by the Auto Close feature found on SQL Server
Resolution:
Log in to SQL Management Studios and expand Databases. Locate the ksubscribers database and right-click, select Options and locate Auto Close
If this feature is set to "True", please change it to "False".