How to know when(Time) the sql server services were stopped?
-
Hi,
I have a small doubt that can we know the time when sql server services were stopped after starting services.....?
Just for clarification i am asking the above...means by checking the system log or any thing....and also how to know the reason why they were stopped(Problem)?
Please clarify my above doubt?
Bhagath
-
The two main places is the SQL Server log and Windows Event log.
It's likely that in case of error that causes the server to stop, you can find the time and cause in either or both of those logs.
If SQL Server is stopped on purpose, that too is logged, though the reason is unknown. (the thoughts of the person stopping the services aren't logged
).. at least not yet
/Kenneth
-
Ok.Thanks allot for your information.I have searched and found in event log...Thank You.
Bagath.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply