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 |
|
aplanting
Starting Member
1 Post |
 Posted - 2009-10-26 : 15:47:40
|
| hello all,not sure which forum it should be under but will try this one.I need some advise on the next setup.we have in place two servers, 1 in a datacenter hosting our website and 1 in our office. We have an dedicated VPN connection from and to each other. Both servers are running SQL 2008 standard. The website is being re-designed to match the database layout we have in our office.we have a couple of users that connect through an application and have 2 users that queries the database all day long.what would be the best possible setup for this to avoid heavy queries interfering with normal operations. and how do i maintain the same data online and offline.I've read about several solutions such as db mirroring and replication but i am puzzled about the best solution for us. resume, should i let the users connect to the online db for regular operations and how do i sychnronize the data between the two servers optimally. |
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
Posted - 2009-11-06 : 13:00:46
|
| As per my understanding you are trying to setup a scenario where data will be written on both ends..ie., both server & you have to do a sync bethween them. You could use merge replication in this scenario.Thanks,Krishnawww.SQLServer.in |
 |
|
|
|
|
|
need advise badly