Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dhudson29
Starting Member
23 Posts |
 Posted - 2014-09-22 : 14:59:18
|
| Is there such a thing as Active/Active/Passive Clustering in SQL 2012. I read where someone said since an instance can run on only one node, then the other would not be using any resources. Kind of confused me; but nevertheless is this Active/Active/Passive, really just Active/Active? Any ideas out there? |
|
|
tech_1
Posting Yak Master
129 Posts |
Posted - 2014-09-22 : 15:09:05
|
| http://social.msdn.microsoft.com/Forums/sqlserver/en-US/20a52c5c-6a3c-466d-9e19-c864129d4cf7/always-on-activepassive-sql-server-2012?forum=sqldisasterrecovery |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-09-22 : 15:11:57
|
| An Active/Active/Passive cluster would be a 3-node cluster where 2 of the nodes had at least one SQL instance running on it, and the other is waiting for a failover to happen.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Failover Clustering