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 |
|
DBA007
Posting Yak Master
145 Posts |
 Posted - 2012-07-25 : 06:28:56
|
| Team,Our production sqlserver service was restarted last week.we want to know who restarted the sqlserver service.Please share your experience. |
|
|
sql-lover
Yak Posting Veteran
99 Posts |
Posted - 2012-07-25 : 07:53:24
|
| Check login records in the SQL log, but I think by default SQL logs unsuccessful login attempts only.Checking Windows log, that may help too. |
 |
|
|
DBA007
Posting Yak Master
145 Posts |
Posted - 2012-07-25 : 08:07:30
|
| verified the windows log,but there was no details or login that specifies the sqlserver restart. |
|
|
|
sql-lover
Yak Posting Veteran
99 Posts |
Posted - 2012-07-25 : 12:11:11
|
quote:
Originally posted by DBA007
verified the windows log,but there was no details or login that specifies the sqlserver restart.
Check who was logged just before, at Server level. It may give you a clue.Like I said before, if MS-SQL has not been configured to do a full audit, successful events won't be recorded on the SQL log I think. |
|
|
|
|
|
|
details of sqlserver restart