JnavarroMc
asked on
Geo Clustering SQL Server 2008 R2
I would like to help to plan the prerequisites for the implementation of SQL Server Clustering Geo.
I have a total of 4 servers for this purpose. two on the Site A and two at Site B.
Need to determine the servers that act as actives and inactives. And all the tools I need
Thanks!
I have a total of 4 servers for this purpose. two on the Site A and two at Site B.
Need to determine the servers that act as actives and inactives. And all the tools I need
Thanks!
ASKER
the project has already been established by geo clustering.
I have 2 nodes on the main site and 2 nodes on the secondary site. The replication of storage is also provided.
What I can not understand so far is how could structure these four nodes.
We were planning to have an active and passive node on the main site and the other two nodes in the same way at the remote site.
What I can not understand is how this solution could work as it would have two main nodes. Or is that only would have a major node on the main site and the other three nodes would be passive?
I have 2 nodes on the main site and 2 nodes on the secondary site. The replication of storage is also provided.
What I can not understand so far is how could structure these four nodes.
We were planning to have an active and passive node on the main site and the other two nodes in the same way at the remote site.
What I can not understand is how this solution could work as it would have two main nodes. Or is that only would have a major node on the main site and the other three nodes would be passive?
what are you going to run and A node in each DC?
explain your servers topology
Active means -something will run there-
does it mean 1 site A and 2md site P
and vice versa?
please clarify
explain your servers topology
Active means -something will run there-
does it mean 1 site A and 2md site P
and vice versa?
please clarify
ASKER
I found a clarify diagram!
http://windowsdummies.blogspot.com/2012/09/part1-4-node-multi-site.html
Check!
http://windowsdummies.blogspot.com/2012/09/part1-4-node-multi-site.html
Check!
very good.
what about my question about how are you going to use these windows A/P Geon nodes for your sql server?
if it was sql 2012 - Always on feature may be not so bad idea to use for these nodes settings
for sql 2008 what is your plan?
what about my question about how are you going to use these windows A/P Geon nodes for your sql server?
if it was sql 2012 - Always on feature may be not so bad idea to use for these nodes settings
for sql 2008 what is your plan?
ASKER
I have licenses of SQL 2008 R2. what is the difference with SQL 2012 Always on?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
and Windows setup,
for sql 2008 you may consider Mirroring\Logshipping\sql replication\etc. instead of GeoClustering.
...
You may start from upgrading sql2008 to sql 2012 and use Geo Clustering
via Always On sql 2012 new feature
/ http://technet.microsoft.com/en-us/sqlserver/gg490638.aspx /
SQL Server Multi-Subnet Clustering (SQL Server
http://technet.microsoft.com/en-us/library/ff878716.aspx
if just you need for DR - you may need just Logshipping solution ( http://technet.microsoft.com/en-us/library/ms187103(v=sql.105).aspx )