Which logs do I have to collect when I am victim of an unexpected failover?

Cluster failover SQL : Which Service log do I have to collect when I am victim of an unexpected failover? Several of my customers uses to ask me : “what kind of information they have collect to make a root cause analysis of the unexpected failover on their SQL Server 2005/2008 failover cluster instance on…


Installation of SQL Server 2005/2008 clusters on Windows 2003/2008

Installation SQL Server 2005/2008 failover clusters on MSCS Windows 2003/2008 The installation process between SQL Server 2008 and 2005 failover clusters are different. With SQL Server 2008 in cluster you must run the setup process for SQL Server individually on each node of the failover cluster. To add a node to an existing SQL Server…