Follow

Ksubscribers Database Keeps On Going To Recovery Mode

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

autoclose.jpg

 

If this feature is set to "True", please change it to "False".

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.