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 |
|
iansr
Starting Member
23 Posts |
 Posted - 2002-12-19 : 05:06:08
|
| Greetings!For some reason, the SQL Server in my testing machine seems to stop after a prolonged period of inactivity (It could easily be resolved by right-clicking and selecting start). I also enabled the "start sql server automatically/start sql server agent automatically if it stops unexpectedly". It remains to be seen if this solves it. Will it?I am interested on why it stops? Is there an ultimate solution?Thanks!Ian |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-12-19 : 09:16:28
|
| Bit odd - there should always be system threads running.Do you get anything logged in the NT log or server log?Are you sure it's not due to someone backing up the disk or running something else (virus scan, defragment, ...)==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy.Edited by - nr on 12/19/2002 09:17:52 |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-12-19 : 13:50:53
|
| I doubt that SQL Server is stopping due to inactivity because SQL is always doing something in the background. The Event log should let you know what is happening. Check out the application log first to see what SQL Server says about it, then check the System log to see if there are any stop errors. If there are, you are going to need to correct these errors. |
|
|
|
|
|
|
SQL server stops unexpectedly due to inactivity