cancel
Showing results for 
Search instead for 
Did you mean: 

confused

sara-collins
Level 3

I am new to cluster server, how many sql server machines can you have in a cluster? i have a client that has a master server and a standby, now he wants a third standby my question should we make it a cluster, or is log shipping the best option?

 

1 ACCEPTED SOLUTION

Accepted Solutions

erin4fry
Level 3
f you want to span the globe with your cluster--make sure you're running Windows2003 and you can setup a geographical cluster--it's specifically designed for cluster servers located in geographically different areas. If you can only afford 15minutes of downtime, you either need a cluster or transactional replication--I think logshipping would have too much latency.

View solution in original post

2 REPLIES 2

erin4fry
Level 3
f you want to span the globe with your cluster--make sure you're running Windows2003 and you can setup a geographical cluster--it's specifically designed for cluster servers located in geographically different areas. If you can only afford 15minutes of downtime, you either need a cluster or transactional replication--I think logshipping would have too much latency.

sara-collins
Level 3
Thanks , I posted your answer under question for future reference.