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 |
|
krasooli
Starting Member
1 Post |
 Posted - 2008-03-04 : 04:07:26
|
| Hi all,I am wondering if there is a way that the SQL server resets every few hours. I am using an application which is heavily utilising SQL server and the server crashes every now and then. I can reset it manually but I was wondering if there is a way that it detects the crash and reset itself automatically. Thanks a million in advance. |
|
|
readysetstop
Posting Yak Master
123 Posts |
Posted - 2008-03-04 : 06:56:34
|
| You can set the service to auto-restart on failure in the services control panel. Although, if I were you, I'd make it a bigger priority to find out why SQL is crashing so often. Work on fixing that first. -D.____________________________________________________________________________________"Believe in those who are seeking the truth. Doubt those who say they have found it." -Andre Gide |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-04 : 23:32:46
|
| Agree, check sql server log and windows event logs for possible cause. |
|
|
|
|
|
|
Automatically reset SQL Server