SharePoint Disaster Recovery (DR) setup in two datacenter accross geographical locations

See more:

SharePoint

SharePoint2010

, +

Hi All,

My company has SharePoint 2013 portal with 1200 users globally. We are planning for SharePoint 2013 DR setup with datacenters existing in India and US.

I followed article at http://technet.microsoft.com/en-us/library/ff628971.aspx

So we have one SharePoint 2013 and SQL Server 2012 Servers at both Datacenters. They are NOT in farm. Custom solutions are deployed on both of them. India datacenter is primary(Active) and will keep running until disaster happens. In case India Datacenter goes down, US datacenter (Passive) will be up automatically using DNS IP failover mapping (Primary IP points to India and failover IP to US datacenter).

Now somehow we need to keep Databases in sync with each other. For that we preferred Two Way Replication. But this requires each table of Database to have Primary Key. Our DBAs identified around 75 tables in SharePoint Content database that DO NOT have Primary key.

Will it be a good idea for us to manually add Primary Key to those 75 tables (Identity columns) to support two way Replication?

Please advice....thanks in advance.