Hi All, My scenario is two locations are there and this two different location servers are going too replicated. We are going to use the db servers as based on location. Example if users are accessing database which is located in India for them separate db server and users who are accessing database which is in USA for them separate database server. These both database will be replicated. If both location users are accessing single database is not a problem. If one link is down automatically another link will come up and users are able to access. If both links are up users are able to access to their database based on the location. Example if user is in India than he must be access only database which is in India. Here problem is if both links are up user can't access other location databases. What will happen if user in one location can access the database which is in another location? How to restrict users? Please suggest what complications we are going to face this type of situation.
Is your question more of how to redirect users to different locations or how to keep the databases in these two locations in sync? If its the latter, then check out Peer to Peer Replication in SQL 2005.
My doubt is from application point of view is there any difficulities are there. How we have to redirect to different server and in my application scenario overwritten will occurs for that reason i am asking. please suggest thanks, kumar
