June 18, 2009 at 9:28 am
Hi,
We have a sql server 2 node Active/Passive environment.
I have couple of doughts
-----------------------------------------------------------
When I stop the SQL Server on active node, It will failover to secondary node, at this time I could see the below Message in sql server log
"SQL Server is terminating due to 'stop' request from Service Control Manager." then SQL Server recovery of the database message...
at this time will tempdb will be recreated?
In my case I am seeing tempdb creation data and time is same as fail over date and time.
-----------------------------------------------------------
Can some one help me what Messages will be logged in SQL Server Error Log at the time of failover?
Where do I find the info about successful failover?
-----------------------------------------------------------
Rajesh Kasturi
June 18, 2009 at 11:41 am
If it is a clustered SQL Server, you'd better manage the failover from the cluster administrator by moving group instead of simply shutting down the SQL service.
June 18, 2009 at 3:25 pm
What are you trying to achieve, are you trying to catch\alert on a failover?
June 22, 2009 at 11:41 am
I am trying to find the SQL Server Errorlog messages while moving the sql server resources from one node to the other node.
I would like to see the sql server error /warning messages at the time of cluster fail over.
Rajesh Kasturi
June 22, 2009 at 3:59 pm
Check windows event viewer application logs and see if it helps.
MJ
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply