Call manager SQL query stopped suddently

[auraycats]

Some query services stopped suddendly, I can not run CRD in serviceability tool and can not run Query analyzer to retrieve detail data. Does any one know how to check the service and retart the service without reboot the system?

[Aaron Harrison]

Hi

Log onto the CallManager server desktop, and then click on 'start', 'run', and type 'services.msc'

This will give you a list of all system services.

On the right, click on the 'Startup Type' column to sort them in order of which start automatically. If any have 'Automatic' but do not have 'Started' in the 'Status' column, they should probably be restarted.

The most likely service to have failed will be MSSQL.

Regards

Aaron

Please rate helpful posts....

[auraycats]

I found crd scheduler no status and restarted it. and this process did not help. re attachment

[auraycats]

I rebooted the call manager but no luck to get cdr and query analyzer work.

[auraycats]

I found the resolution. the db (cdr) was marked as suspect. I followed this procedure to open and resume my query.

Database has been Marked as Suspect

Downloads

Database has been Marked as Suspect

Document ID: 26780