September 15, 2014 at 1:18 pm
Hi Folks,
Just configured a three node ACTIVE/ACTIVE/PASSIVE SQL 2008 cluster on Windows 2008 R2.
Here is the specs:
Node Name: HA1
Node Name: HA2
Node Name: HA3
Windows 2008 R2 Cluster:
WIN2K8 - 192.168.168.5 - Node Majority - HA1,HA2,HA3
SQL Server 2008 Virtual Network Names:
Named SQL Instance: HR
HRSQL - 192.168.168.10 - Running on Active Node HA1 - Will Fail over to HA3 - HR_DATA on H: and HR_LOG on R:
Named SQL Instance: SALES
SALESSQL - 192.168.168.15 - Running on Active Node HA2 - Will Fail over to HA3 - SALES_DATA on S: and SALES_LOG on L:
Everything is working just as expected, not sure how to utilize Passive Node HA3 for Backups.
Any suggestions please?
Flex
September 18, 2014 at 2:58 am
FlexBrains (9/15/2014)
Everything is working just as expected
Yep, seems reasonable setup to me.
FlexBrains (9/15/2014)
not sure how to utilize Passive Node HA3 for Backups.Any suggestions please?
Flex
Ah, you have deployed Failover Cluster Instances of SQL Server, the feature you mention above is native only to AlwaysOn Availability groups in SQL Server 2012 onwards.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 19, 2014 at 8:24 am
Thanks, this is what our next goal is. HA on SQL 2012.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply