Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jmidd22
Starting Member
1 Post |
 Posted - 2010-10-14 : 22:06:13
|
| I have had an ongoing issue with SQL server stopping. Everynight at 3am SQL will shutdown. I have tried to find out what is causing this and it appears to be a failing SQL update from MS updates. I tried to manually install it and it wouldn't complete successfully, so it keeps trying over and over. When it fails to update, it stops SQL.In the SQL log file it shows:2010-10-15 01:00:30.89 spid53 Starting up database 'ASPState'.2010-10-15 01:00:31.30 spid53 Starting up database 'SSA'.2010-10-15 03:00:24.46 spid11s Service Broker manager has shut down.2010-10-15 03:00:25.16 spid5s SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.2010-10-15 03:00:25.16 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.I set the service to start up again after failure, but it WONT restart the service. So I took the next step and created a script (*.bat) that restarts SQL services. I set this as a daily scheduled task to run at 3:02am - giving the errored SQL to completely stop.This "band-aid" was a working method of success for me up until 2 weeks ago when it stopped working. I noticed the bat file was moved and our system admin password was changed, so I knew the script wouldnt run. I reconfigured the scheduled task to map to the new location of my *.bat file, and re-entered the RUN AS ADMINISTRATOR + password info. Still the next day I came in, SQL is stopped. This is a hastle because our staff comes in at 8am, and I get in at 8:30am - I get calls from 8am-8:30am telling me to hurry up, get to work faster, come in early, etc... I need this fixed ASAP and I was wondering if anyone could help me? Thanks in advance. Please email me through the site or direct to jmiddleton@guconstruction.net, thanks.Kindest regards,Jaron Middletonwww.ssguam.com |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-10-15 : 01:14:54
|
First you should disable the automatic update so your server won't stop every night.Then you should find out if other people have had this problem too and how they solved it.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
|
|
SQL Server Stops EVERDAY