SQL Server 2008 R2 Express, service stopping on server?

Its was set to automatic start – Truegilly Jul 12 '10 at 9:50 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 Jul 12 '10 at 17:22 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 Sep 1 '10 at 0:04.

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.

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

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.