If I install a two node cluster with the MS SQL 2005 default instance on node 1 and a named instance on node 2 is this considered and active/active configuration? Both nodes will have active databases. Thanks.
For each instance you should have the SQL Server and the SQL Server Agent services on every node. So, for an active/active installation that means two SQLSERVER services, and two SQLSERVERAGENT services in service manager. If not, you haven't got an active/active cluster. Get a clarification for your doubts fromhttp://www.sql-server-performance.com/bm_cluster_sql_server_2005.asp link Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Check the following too... http://www.microsoft.com/technet/technetmag/issues/2007/03/sqlclusters/default.aspx MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.