January 30, 2012 at 6:37 am
Hi,
Can any one please let me know where we have to check the following cluster information.
1).When was the cluster failover was happened and from which NODE it is moved.
January 30, 2012 at 6:56 am
You will find both information in Event Viewer.
As for the server startup (approximatley 2 minutes after the failover) you can query that information from sys.databases (it's the date when tempdb was created).
SELECT create_date
FROM sys.databases
WHERE name = 'tempdb'
-- Gianluca Sartori
January 30, 2012 at 10:12 am
vijay82 (1/30/2012)
Hi,Can any one please let me know where we have to check the following cluster information.
1).When was the cluster failover was happened and from which NODE it is moved.
is this windows 2003 or windows 2008 cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 31, 2012 at 9:13 pm
It is win 2003 server.
January 31, 2012 at 9:38 pm
Windows Cluster Management will show all events and log of service failure & node failover.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 31, 2012 at 11:46 pm
vijay82 (1/31/2012)
It is win 2003 server.
In that case check the cluster log at the following path
C:\windows\cluster\cluster.log
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply