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.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Data Collection from many to one servers

Author  Topic 

netjam
Starting Member

37 Posts

Posted - 2008-03-07 : 00:58:32
I need to feed head office sql server with the data from regional servers. Servers are spread through all continents
Data input done locally on Head office server as well and plus need to ship data from other servers.
So clarify this - Head office server is not standby one. Mirroring is out of the picture, I think..
Initially, I thought ship a log every 15 min and restore on Head office server but is this going to create an issue for the local data processing?

Any bright ideas welcome!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-07 : 09:12:02
what about Merge Replication?
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-07 : 22:42:24
Can't use log shipping in this case.
Go to Top of Page
   

- Advertisement -