SQL Programming
Debugging Database Recovery causes
My webconnect app uses a SQL Express database for both the webconnect tables and my application.
Every few days SQL goes into recovery mode on that database and I'm at a loss for exactly how to debug it. Of course, until it finishes recovery, the tables are not accessible and my app chokes.
Any hints or articles on how I can track down the cause?
TIA
I found a nice tools in ApexSQL Manage (free trial) that analyzes your SQL server database and recommends setting changes - including the T-SQL code to run in order to make the change for you. Sweet.
https://www.apexsql.com/sql-tools-manage.aspx
I'm making those changes today and will watch it for a week or two to see if my issues get resolved.
Any other suggestions are still welcomed...