We are going to Implement DR Site for SQL Server 2008 R2.

We have the following  configuration on Primary Site.

1. SQL Server 2008 R2 ( Stand Alone )

2. SQL Server 2008 R2 (2 Node Failover Cluster)

DR Solution will be on SQL Server 2012

Kindly guide how will i configure DR solution for Single SQL Cluster and for Failover Cluster.

ON DR SIte i will configure separate failover Cluster instance or no it will work with the same instance on primary site....??

Is that work with sql server 2012..i have sql 2008 on primary can i configure sql server 2012 on DR Site....

Please help???

• Edited by Dev0099 Monday, August 24, 2015 7:46 AM

DR is normally with the same SQL version because you would never know how application is going to behave if SQL is 2012.  Its possible to have SQL 2012 as log shipping secondary but remember that your can't come back to original primary if you failover.

I would suggest have discussion with application team before making decision.

DEV,

Before even going ahead we need to know the RPO and RTO basically amount of data loss acceptable. I can understand you want to learn but the discussion would require some prerequisites to give you meaningful answer

SQL Server provides

1. Mirroring

2. Logshipping

3. replication

As means of DR teachnology.

Clusters does not provide DB redundancy it provides OS redundancy. Plus even if you have DR configured at DB level and OS level, people do go for SRDF which is DR at storage level.

Thanks...

We are going on storage level...San to San replication....

Thanks...

so i must use the  same version ...sql server 2008 R2....

so if we have failover clustring in sql server 2008...can we configure it on dr site via san to san replication..

Thanks...

so i must use the  same version ...sql server 2008 R2....

so if we have failover clustring in sql server 2008...can we configure it on dr site via san to san replication..

Correct, use same version and if possible edition as well. If you failover from enterprise to standard the Ent features would not work.

Why are you confusing Clustering with SAN replication both are independent. You can have cluster on both DR and PR level and Storage from PR can be replicated

OK thanks...

1 question more about Quorum configuration.

we are going on san to san replication and both sites will be active active..means Disaster site will be active but will not reporting to primary site.

Primary site don't know about disaster site..but same replica is running on DR site.and Data is replicating with san to san replication....during disaster network hardware component is used to route the traffic during disaster.

what will be our quorum configuration in this scenario

• Edited by Dev0099 1 hour 6 minutes ago