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

Operating Systems
Windows, Linux, Solaris, Red Hat, etc.....32 bit or 64 bit.
If its an OS, its here.
Post Reply
roberthubs7
Legit Little One
Legit Little One
Posts: 1
Joined: Mon Nov 16, 2015 5:05 am

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

Post 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.
User avatar
KnightRid
Moderator
Moderator
Posts: 4295
Joined: Wed Dec 14, 2005 5:21 am
Location: Dallastown, PA

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

Post 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.
Remember, I am opinionated and nothing I say or do reflects on anyone or anything else but me :finga:
Post Reply