SQL Programming
Debugging Database Recovery causes
Gravatar is a globally recognized avatar based on your email address. Debugging Database Recovery causes
  Michael Hogan (Ideate Hosting)
  All
  Jul 19, 2021 @ 08:35am

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

Gravatar is a globally recognized avatar based on your email address. re: Debugging Database Recovery causes
  Michael Hogan (Ideate Hosting)
  Michael Hogan (Ideate Hosting)
  Jul 19, 2021 @ 09:53am

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...

Gravatar is a globally recognized avatar based on your email address. re: Debugging Database Recovery causes
  Michael Hogan (Ideate Hosting)
  Michael Hogan (Ideate Hosting)
  Aug 16, 2021 @ 07:38am

Well, all has been well since my SQL settings were changed based on the recommendations from ApexSQL Manage... It is now on my 'Highly Recommended' list.

© 1996-2024