Good question..

But it was a mental note to-self as I looked at the code about the SET IDENTITY_INSERT TblA1 ON; etc, and remebered I come across the IDENTITY_INSERT on/off...

Hi,

Not sure if these links would help (they are based around 2008 R2)?

SQL Server 2008 and R2 Cluster Best Practices

http://blogs.msdn.com/b/pamitt/archive/2010/11/06/sql-server-clustering-best-practices.aspx

Installing:

http://msdn.microsoft.com/en-us/library/ms179410%28v=sql.105%29.aspx

Hardware:

http://msdn.microsoft.com/en-us/library/ms189910%28v=sql.105%29.aspx

*slightly embarrassed* - It seems to be working now.. I have a feeling it might have been how I was setting up the counters. I’ll keep it running for...

I believe so, but I will double check (I could be having a moment!)

It is indeed a passive/active node system.

It's just strange that when I try to use Perfmon to view the active node's counters I get nothing.