Page 1 of 1

MS SQL Database could not be recovered. Diagnose errors or r

Posted: Mon Nov 16, 2015 5:12 am
by roberthubs7
A program (Chiro8000) cannot be started, and fails with an error: "It appears SQL service is not running. Please ensure that it's running and try again."

The SQL service is, in fact running; however, there is an error in the event logs:

An error occurred during recovery, preventing the database 'PM_CHIRO_V12' (database ID 5) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.

How do I diagnose errors in an MSSQL database? I would prefer not to have to restore from a backup since the owner of this machine probably does not have one.

SQL Server Version: MSSQL 2005.

Re: MS SQL Database could not be recovered. Diagnose errors

Posted: Tue Nov 17, 2015 4:57 am
by KnightRid
I have no first hand knowledge of SQL but I found these...

https://msdn.microsoft.com/en-us/library/ms176064.aspx

https://support.managed.com/kb/a398/how ... mssql.aspx

Hopefully one of those would work or someone else will know more about the subject for you.