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 |
|
kpparvathaneni
Starting Member
4 Posts |
 Posted - 2004-11-09 : 13:22:08
|
| On an active/passive cluster, is it possible to set up transactional replication from a database on the active server to a standby database on the passive server? Please help me. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-11-09 : 14:40:02
|
| Well yes and no. The scenario you describe is possible, but not on an Active/Passive setup. Active/Passive implies that SQL is running on just 1 node, and only if failover occurs does the other node run SQL. If SQL is running on both nodes (Which would be required to do what you want to do) then you would need Active/Active, and thus need Enterprise Licenses for both Servers.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
MuadDBA
628 Posts |
Posted - 2004-11-09 : 14:40:54
|
No. I'm not sure you understand the nature of active/passive configurations...the passive server is not running SQL services or anything until the heartbeat from the active server stops, then it fires everything up.doh! |
|
|
|
kpparvathaneni
Starting Member
4 Posts |
Posted - 2004-11-09 : 18:04:27
|
| Thanks for the response. Is it possible to set up another stand alone instance of SQL server on the passive server and replicate to a standby database on that instance? Does it still need licenses? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-09 : 18:11:57
|
| You can do that, but it won't be active/passive anymore. It'll be active/active, so you'll need licenses on both.Tara |
|
|
|
kpparvathaneni
Starting Member
4 Posts |
Posted - 2004-11-09 : 18:59:36
|
| Thanks to everyone who replied. |
|
|
|
|
|
|
Replication and clustering