October 17, 2005 at 10:02 am
All,
We are building an Active/Active SQL Server Cluster server for State Management. ASPSTATE database is used for SM services. When a failover occurs, the active node will host both SQL Server instances and the two ASPSTATE databases from each instance will coexit on the alive node. Could this (identical db names from separate instances) cause any problem?
Thanks,
Yichang
October 17, 2005 at 12:41 pm
From the instance perspective there is Only ONE Db so I don't think it can cause a problem!!!
* Noel
October 17, 2005 at 4:42 pm
You'll have two SQL Server instances (call them A and B). Each SQL Instance will contain an instance of database ASPSTATE... and those database are differentiated by the SQL Server instance hosting them. Thus, you'll have
A.ASPSTATE
B.ASPSTATE
Under normal circumstances there will be one instance on each cluster node. If one node fails (say, that hosting A), the other node will "take over", and both instances will now be running on the surviving node.
You applications will be (??) designed to reference one and only one SQL Server instance (that's part of your connection string, be it ODBC, OLDE DB, JDBC, or whatever)... and they won't care which box is hosting the SQL Server/database instance they are referencing.
Philip
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply