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

  • Article

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 their Windows 2008? "

You could find below 2 methods:

Cluster failover SQL : Quels sont les logues que je dois collecter lorsque je suis d'un basculement inattendu ?

De nombreux clients me demande régulièrement : "quels types d'informations devons-nous recueillir pour analyser les causes d’un basculement inattendu sur notre instance SQL Server 2005/2008 en cluster failover sur Windows2008 ?"

Vous pouvez suivre une des deux méthodes ci-dessous :

Cluster failover SQL : ¿Cuáles son los logists que recoger cuando estoy en una conmutación por error inesperado ?

Several of my customers used 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 their Windows 2008? " Muchos clientes regularmente me preguntan: "qué tipos de información recogemos para analizar las causas del conmutación por error inesperado en nuestra instancia SQL Server 2005/2008 en Windows 2008 failover clustered ?"

Puede seguir uno de los dos métodos siguientes:

Method 1: This method is the best one to be ensured to get all information that we need for an RCA. Just run the MPS Report tool. it will take a snapshot of all your logs.

https://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F-88B7-F9C79B7306C0&displaylang=en 
Use administrator account
Please, when you run MPS Report, be ensure that the checkbox below are checked:
-              General
-              Internet and Networking
-              Server component
- SQL and other Data Stores (MDAC)

Method 2: You can collect the 5 most important logs by using the command below:

Cluster info:

@ECHO OFF
ECHO %DATE% > C:\temp\clusterinfo.output.txt
ECHO %TIME% >> C:\temp\clusterinfo.output.txt
CLUSTER /QUORUM >> C:\temp\clusterinfo.output.txt
CLUSTER RES >> C:\temp\clusterinfo.output.txt
CLUSTER RES /PROP >> C:\temp\clusterinfo.output.txt

Cluster log:

CLUSTER /CLUSTER:cluster_name LOG /GENERATE /COPY:”c:\temp”

Event windows:

Step 1: Start >> Administration tools >> Event viewer

Step 2: On Application et System save as in .CVS

Step 3: Also observe the cluster Operational log – Microsoft >> Windows >>FailoverClustering Operational.

 

Michel Degremont| Microsoft EMEA
Product Support Services Developer -SQL Server Core Engineer |