Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Windows Server Restart Expand / Collapse
Author
Message
Posted Wednesday, March 12, 2014 2:23 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, August 28, 2014 9:35 AM
Points: 67, Visits: 175
Some one restarted by Windows Server 2008. On which SQL Server has installed.

can any one tell me how to find who restarted the server ant what time ?
i did check in Event log but there is no such information.
Post #1550067
Posted Wednesday, March 12, 2014 3:04 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
check following link:
http://www.techtalkz.com/windows-server-2003/39348-server-2003-restart-log.html

HTH


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1550083
Posted Wednesday, March 12, 2014 7:44 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 1:06 PM
Points: 2,829, Visits: 8,479
sreenubabu.s (3/12/2014)
Some one restarted by Windows Server 2008. On which SQL Server has installed.

can any one tell me how to find who restarted the server ant what time ?
i did check in Event log but there is no such information.


There's no entry in the event log ?!?!?!

Or did it get erased ? I usually search with a filter for the event number, or sometimes omit the informational logs to see just the more important ones.

I am on Windows 2003, but I assume 2008 has the same options, if not more.



Post #1550507
Posted Wednesday, March 12, 2014 8:32 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 21,749, Visits: 15,443
Sometimes log entry doesn't get written when windows update causes the reboot. You might want to check the windows update log.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1550513
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse