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 |
|
satya.katari89
Starting Member
9 Posts |
 Posted - 2013-05-08 : 04:07:17
|
| Hi guys,we have one database in Hyderabad location few of our team members will be working from MUMBAI as well. as of now we are working on remote desktop connections. we would like to look for speed up the process.Remote desktop is very slow even though we have LEASED LINE Connection.Can any one suggest me ? is it possible to implement any Replication , im worried when the connection is going Down what will happen ?can any one suggest me ? -Satya |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-08 : 04:45:58
|
| you can create a copy for other location and set up transactional replication if you want.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
satya.katari89
Starting Member
9 Posts |
Posted - 2013-05-08 : 04:50:25
|
| If the Connection Leased Line Connection Goes Down; if any update is happening in Hyderabad , and at the same time on same table Mumbai also updates what will happen to the data once the leased Line connection comes to normal.-Satya |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-08 : 05:29:17
|
| depends on how you configure the publisher and distributor tpology. there can be peer - to peer - transactional replication which can be used for high availability------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
satya.katari89
Starting Member
9 Posts |
Posted - 2013-05-08 : 05:56:31
|
| can Mumbai Team can directly connected to Local SQL server and HYderabad Team can connect to Hyderabad Server.im worried about data conflicts. how can we take care ?If possible please provide me the procedure of setting up.-Satya |
|
|
|
satya.katari89
Starting Member
9 Posts |
Posted - 2013-05-09 : 23:35:53
|
| any one can help me in this regard ?-Satya |
|
|
|
|
|
|
SAME SQL Server Over Two Locations