January 30, 2010 at 9:13 am
Hello Experts
There was a requirement to change the 'MAx Server Memory' of a server. I changed and after that moved the SQL Server, SQL Server Agent to offline and then brought those online again since the server is in cluster. unfortunate thing is, I can't find the details in the event viewer that the resources were kept offline by the time by me.
I checked in Application, system event viewer and also in Cluster.log file, but could not get the details.
Pls assist me..
Thanks.
January 30, 2010 at 11:50 am
Hi Sourav,
To be frank when ever we failover/move resource we have a entry logged in Event Viewer and ofcourse cluster logs. One thing in cluster logs times are in UTC format so what ever time zone you are you need to make adjustment in time as per that.
I must say in case you are no seeing any entry in Event Viewer/Cluster logs (which is doubtful) then you can go to SQL Server Error Logs there you will find a entry when last time SQL Server was taken offline and brought back online.
I hope this will help.
Regards
GURSETHI
January 31, 2010 at 12:08 am
I think I missed you mention that I checked in ErrorLog also (all the error logs generated on the day), but could not find the details. Bad luck !!
Thanks.
January 31, 2010 at 1:16 am
Hi Sourav,
Please send me below logs.
1) SQL Server Error Logs
2) Application & System Event Logs (Saved in Text Delimited Format)
* Please don't save in EVT format
3) Cluster.logs
Regards
GURSETHI
(sethigurpreet@yahoo.com)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply