Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vfichadia
Starting Member
1 Post |
 Posted - 2008-06-19 : 03:37:41
|
| Hi all,We need an architecture in which one office is in pune and other in mumbai, principal server is in pune and mirrored in mumbai,now we need an architecture in which mumbai user will performing read only operation from mumbai server (local server )and write operation in pune server(remote server)and pune user will be performing read and write operation in pune server(local server)now when link between pune and mumbai goes down, mumbai users will not be having acess to pune server so at that time mumbai user will not be performing write operation in pune server (local server) and when link goes up we want mumbai server to get updated with pune server.how this is possible or any other different solution to this, what mandatory is we want mumbai users to perform read operation from mumbai server ONLY.Regards,Vinit FichadiaThanks,Vinit Fichadia |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-06-19 : 05:01:27
|
| I guess you have to determine programatically if the link is down or not and if it's down then deny read-access to the mumbai server. If you're using transactional replication in 2005 you might be able to use this latency procedure to determine if the link is up or down: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=104696- Lumbago |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-19 : 09:21:43
|
| You need to assign permission what they need to do in which server.Transactional replication is a good option. |
|
|
|
|
|
|
Synchronization of Database at different location