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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-02-26 : 10:17:51
|
| Wasim writes "HiFor 15 days now my SQL server service is terminating with the following errorMSSQLSERVER service terminated unexpectedly. It has done this 2 Time(s).This service terminates and restarts automatically and sometimes doesnt restart we have to mannuly start it again.Event ID: 7034.Version DetailsVersion: MSSQL Server 2000Service Pack: 3aBuild: 8.0.0.760I have checked many forums most of them suggest to apply the latest service pack. But the same error has been reported by sites having SP4 also.Kindly help.Thank youwasim" |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-26 : 11:16:23
|
| What is triggering the SQL Server to terminate?Backups? Long-running queries?Peter LarssonHelsingborg, Sweden |
 |
|
|
rlaubert
Yak Posting Veteran
96 Posts |
Posted - 2007-02-26 : 14:45:39
|
| Since you know when it started, let's start with what changed just prior to that. If it was working fine up until then, something in the OS, SQL, MAintenance, Operations etc much have triggered the change. Also look at the SQL jobs, event logs, sql logs etc and see if it is the same time each day. That may help identify the problem. I had one were the server was shut down every night around 9 PM. Then restarted about 9:30 or so. Found out later that a new cleaning person was pulling the plug on the server to run a vacumn. (This was a small business and didnt have a dedicated server room).By looking that the logs (Windows and SQL) you should be able to provide some more details as to what is going on at that time. Let us know.Raymond LaubertMCDBA, MCITP:Administration, MCT |
|
|
|
|
|
|
SQL server terminates