February 26, 2007 at 12:26 am
Hi,
My web application which uses sql server 2005 ( server A ) to store data. Users from different location access Server A.
As load increses we deciced to replicate ( peer to peer transaction replication) data to Server B.
My question is
1. How I will direct the users from location B to Server B instead of Server A?
Thanks and Best of regards,
Minaz Amin
"More Green More Oxygen !! Plant a tree today"
February 26, 2007 at 2:29 pm
I am not sure if there's an "automatic" way to switch your user between the servers. Perhaps you can set some timeout property in your application and use Primary and Secondary servers in your connection string? I am just theorizing here. You can test it out.
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
February 27, 2007 at 12:15 am
Thanks Dinakar.
we decided to do the same as you said, use connection string in the application which will check the domain and redirect it to the respective server.
Have nice day.
Regards,
Minaz Amin
"More Green More Oxygen !! Plant a tree today"
February 27, 2007 at 11:05 pm
You can use the load balancing device like CISCO CSS for this...
MohammedU
Microsoft SQL Server MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply