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 |
|
kuttan939
Starting Member
4 Posts |
 Posted - 2008-04-13 : 04:56:05
|
| HiI am using a sql server database for storing gps data from a remote location. The average data stored in the db is around 2 GB/day. For security reasons, my application is working on another server which has same db. I need to update data in the second database within an interval of 2 seconds. The user entry in the application server has to be synchronised with first server also. Is replication is possible in such a small interval?. Anybody have any suggestion?Thanks in advanceKuttan |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-13 : 16:14:40
|
| Why don't let app server write to both sql servers at same time? |
 |
|
|
kuttan939
Starting Member
4 Posts |
Posted - 2008-04-14 : 04:00:10
|
quote:
Originally posted by rmiao
Why don't let app server write to both sql servers at same time?
Actually app server is only used for reporting. The data is recieved from remote location to the first server. That server is to be synchronised with app server for reporting |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-14 : 10:39:38
|
| Yes replication will be good option |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-14 : 23:24:12
|
| But it can't guarantee to update data in the second database within an interval of 2 seconds. |
|
|
|
|
|
|
SQL Server Synchronisation