SQL Server Performance

replication prb

Discussion in 'SQL Server 2005 Replication' started by srimkumarp, May 8, 2009.

  1. srimkumarp New Member

    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.
  2. ndinakar Member

    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.
  3. srimkumarp New Member

    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

Share This Page