Ask the Community
Groups
Ksubscribers Database Keeps On Going To Recovery Mode - Connect IT Community | Kaseya
<main> <article class="userContent"> <p><strong>Problem</strong>:</p> <p>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.</p> <p> </p> <p><strong>Cause: </strong></p> <p>This can be caused by the Auto Close feature found on SQL Server</p> <p> </p> <p><strong>Resolution</strong>:</p> <p>Log in to SQL Management Studios and expand Databases. Locate the ksubscribers database and right-click, select Options and locate Auto Close</p> <p><img src="/attachments/token/y7wiDJKBYwFIRFLDdW1unVGsZ/?name=autoclose.jpg" alt="autoclose.jpg" width="704" height="494" class="embedImage-img importedEmbed-img"></img></p> <p> </p> <p>If this feature is set to "True", please change it to "False".</p> <p> </p> <p> </p> </article> </main>