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.
MS SQL Database could not be recovered. Diagnose errors or r
-
- Legit Little One
- Posts: 1
- Joined: Mon Nov 16, 2015 5:05 am
Re: MS SQL Database could not be recovered. Diagnose errors
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.
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.
Remember, I am opinionated and nothing I say or do reflects on anyone or anything else but me ![Gives thy a finger :finga:](./images/smilies/icon_fU.gif)
![Gives thy a finger :finga:](./images/smilies/icon_fU.gif)