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

SERVER REBOOT REPORT Expand / Collapse
Author
Message
Posted Sunday, January 17, 2010 11:47 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, March 07, 2010 11:38 PM
Points: 46, Visits: 266
Is there any way to know how many times server has been rebooted in last 6 months?

plz help..
Post #848980
Posted Monday, January 18, 2010 1:34 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 5:39 AM
Points: 2,104, Visits: 5,378
Only way that I know is to check old SQL Server’s error logs and\or event viewer logs from that time frame.

Adi


--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #849011
Posted Monday, January 18, 2010 2:23 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 19, 2012 10:25 PM
Points: 1,231, Visits: 3,483
One of the options to get thro by OS level, log would capture in the MMC (Microsoft management console), in the event viewer, unless the disk clean up activity, the records not cleared.. Try with this event logs.
Post #849021
Posted Monday, January 18, 2010 3:46 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, March 07, 2010 11:38 PM
Points: 46, Visits: 266
Is there any SQL command to read system event logs?

if It would help me create reboot report.


Post #849054
Posted Monday, January 18, 2010 4:12 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 19, 2012 10:25 PM
Points: 1,231, Visits: 3,483
Hi,
There is no direct commends in the SQL to call the system event log file, you export the event log files to the local drive as a text file then you use the text file to sql table/reports.
Post #849068
Posted Monday, January 18, 2010 8:07 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, March 07, 2010 11:38 PM
Points: 46, Visits: 266
Even i was also thinking the same way,however i got stuck to implement this process as automated...

is it possible to export the event log to txt file automatically?
Post #849183
Posted Tuesday, January 19, 2010 12:54 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, March 13, 2014 9:27 PM
Points: 3,283, Visits: 6,670
You can write power shell scripts to read from event log using WMI. There are samples out there and you can search for them

-Roy
Post #850064
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse