Is the SQL Service set to manual start, or automatic start?
codekaizen
2010-07-12 09:32:11
hello, its was set to automatic start
Truegilly
2010-07-12 09:50:54
If you look in the Windows event log, you should get notification that either the OS is restarting or that the service stopped. Which is it?
codekaizen
2010-07-12 17:22:37
SQL Server 2008 Express kept stopping on me too daily. I had to keep going into the Services and mark as Automatic and Start.
0A0D
2010-09-01 00:04:49
A:
I still don’t know why it was stopping but setting the recovery options for the SQLEXPRESS service to restart if the service fails has resolved the site from falling over. I has been fine so far. If I discover the cause I will post it here.
Truegilly
2010-07-13 12:14:25
A:
it appears the cause was due to the servers resources being reduced to zero and when that happened it sometimes crashed SQL server, I have ordered a new server, a cloud hosting solution that has much more available ram. In the mean time I have been monitoring my current servers resources, disabling any non essential services and so far so good, no downtime ;)
Truegilly
2010-09-01 18:45:10