Hey all, I've had an issue over the last week or so that's driving me nuts. Every night around midnight, the amazing charts SQL server just stops. I have to stay up nightly and manually start the service again before we open or AC will obviously not run. I'm running SQL Server 2005 on SBS2003, and I've gone over the error logs ad nauseum trying to figure out what could be causing it. You could set your watch to SQL stopping.
I initially thought that the AC Backup could be causing the issue (like stopping the sql server while it backs up the database), but I scheduled it differently and the problem remains. Anyone else dealing with something similar?
