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

Postby roberthubs7 » Mon Nov 16, 2015 5:12 am

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: 3517
Joined: Wed Dec 14, 2005 5:21 am
Location: Dallastown, PA

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

Postby KnightRid » Tue Nov 17, 2015 4:57 am

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.
Cigar Blog I review for - http://www.stogiereview.com


Return to “Operating Systems”

Who is online

Users browsing this forum: No registered users and 2 guests