Hi, I am trying to set up a 2-node active-active SQL 2008 cluster. So it'll be something like:
Data 1, instance 1, node 1, node 2.
Data 2, instance 2, node 1, node 2.
In Failover Cluster Manager, under Services and applications, I have instance 1 with server name Data 1 and instance 2 with server name Data 2. I can do Move this service or application to another node by instnace 1 -> instance 2, or vice versa.
No errors.
Now, I have an application with DB created on Data 2, instance 2. However, when testing the failover in Failover Cluster Manager it went fine and no erros reported, but the application stopped working.
I have a different app with DB created on Data 1, instance 1. This app works fine when testing the failover.
In short, I am puzzled. Where could I check to make sure this active-active cluster was installed and configured as planned?
I checked the summary log in Setup Bootstrap. Sorry about the format. Any suggestions would be greatly appreciated.
Overall summary:
Final result: Passed
Exit code (Decimal): 0
Exit message: Passed
Start time: 2010-11-29 14:44:51
End time: 2010-11-29 15:02:39
Requested action: Install
Cluster properties:
Machine name: FERRARI
Product Instance Instance ID
Feature Language
Edition Version Clustered
Sql Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER Database Engine Services
1033 Enterprise Edition 10.50.1600.1 Yes
Sql Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER SQL Server Replication
1033 Enterprise Edition 10.50.1600.1 Yes
Sql Server 2008 R2 MSSQLSERVER MSSQL10_50.MSSQLSERVER Full-Text Search
1033 Enterprise Edition 10.50.1600.1 Yes
Sql Server 2008 R2 INSTANCE1 MSSQL10_50.INSTANCE1 Database Engine Services
1033 Enterprise Edition 10.50.1600.1 Yes
Sql Server 2008 R2 INSTANCE1 MSSQL10_50.INSTANCE1 SQL
View Complete Post