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 |
|
nman47
Starting Member
8 Posts |
 Posted - 2011-03-17 : 13:57:55
|
| I have new project coming my way where I have been asked to see if we can have a database insync at two different geographical locations. Both databases would be actively used all the time. They both need have new and old information in sync. Is this doable? If so what are the options?I know we can't use missoring or transaction replications because both the mirrored instance and or the replicated instance would have to be in standby mode or can't be active.Any suggestions or recommendations would help.Thank you in advance. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-03-17 : 14:49:25
|
| If both nodes will be written to, Peer to Peer Transactional Replication is probably your best bet.By the way, not true that Transactional Replication requires one instance to be in standby or inactive.If only one node will be written to, but both read from, use Transactional Replication. |
 |
|
|
nman47
Starting Member
8 Posts |
Posted - 2011-03-24 : 14:26:52
|
| Thanks for the replies guys. The suggestions help. I am going to do a bit of digging on the Peer to Peer Transactional Replication. |
|
|
|
|
|
|
Recommendations\Suggestions required?