January 17, 2010 at 11:47 pm
Is there any way to know how many times server has been rebooted in last 6 months?
plz help..
January 18, 2010 at 1:34 am
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/
January 18, 2010 at 2:23 am
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.
January 18, 2010 at 3:46 am
Is there any SQL command to read system event logs?
if It would help me create reboot report.
January 18, 2010 at 4:12 am
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.
January 18, 2010 at 8:07 am
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?
January 19, 2010 at 12:54 pm
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
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply