SQL instances stopping for unknown reason
Posted on 2011-05-06
I am running a Windows Server 2003 box as a Terminal Server. Several programs installed utilize a SQL 2005 instance (Backup Exec, Act, several CCH tax products). Randomly throughout course of a day, and sometimes in middle of the night, all the instances stop.
This can happen several times a day, or not for days at a time. Going into Services and selecting Start for each gets everything back online, so nothing seemingly too major occured, they just stopped.
Looking in the event log has been no help as there does not appear to be any errors happening in any of the logs that coincide with the instances shutting down. As there are no obvious errors, it is also very difficult to determine when exactly they shut down as opposed to when somebody noticed they did.
Anybody have any suggestions of where to begin looking for clues in the system?