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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2012-10-26 : 15:20:29
|
| Hi,How to find out who stopped sql server servics (database service and agent service)?I am facing this situation, SQL Server service and agent service stopped between 12:00 to 1PM. I just want to know why these services stopped. Is there someone who have permissions to do this stuff or it is related to server i.e. memory issue etc.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-26 : 15:48:46
|
| may be server reboot?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2012-10-26 : 17:29:49
|
| I checked event log. In system logs, in front of user name it shows N/A. Not shower who did it. Visakh16:Windows Server was not rebooted. |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2012-10-29 : 16:47:49
|
| Any issue related to memory (low memory) can stop sql server services? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-10-29 : 17:31:51
|
| Possible, but there should be messages in the event log to indicate that. Check all System and Application logs for the time period when the service stopped. |
|
|
|
|
|
|
How to find out