How to generate a cluster log in windows server 2008 ?

The Windows Server 2003 “Cluster.log” no longer exists in Windows Server 2008. you will not find the cluster log under C:\Windows\Cluster.
The cluster log(s) can be generated by the CLUSTER.EXE command. For example:
CLUSTER.EXE YourClusterName LOG /GEN /COPY:”C:\Temp\cluster.log”

Useful commands for SQL server clustering TSQL

— Find the current server is clustered or not

SELECT ‘IsClustered’, SERVERPROPERTY(‘IsClustered’)

—Find SQL Server Cluster Nodes
SELECT * FROM fn_virtualservernodes()

—Find name of the Node on which SQL Server Instance is Currently running
SELECT SERVERPROPERTY(‘ComputerNamePhysicalNetBIOS’) AS [CurrentNodeName]

— Find shared drives for cluster
SELECT * FROM fn_servershareddrives()

— Useful statements for cluster

SELECT CAST( SERVERPROPERTY(‘InstanceName’) AS NVARCHAR(128)) AS ‘InstanceName’
SELECT CAST( SERVERPROPERTY(‘MachineName’) AS NVARCHAR(128)) AS ‘MachineName’
SELECT CAST( SERVERPROPERTY(‘ServerName’)AS NVARCHAR(128)) AS ‘ServerName’
SELECT CAST( SERVERPROPERTY(‘ComputerNamePhysicalNetBIOS’)AS NVARCHAR(128)) AS ‘ComputerNamePhysicalNetBIOS’