May 24, 2004 at 5:55 am
Can we run replication (transactional) and linked servers between two different SQL Servers on the same LAN. Both of which are using same databases for replication as well as for linked servers.
let me explain in detail.
I have two SQL Servers Named A and B.
I want to use Linked servers to copy data from A to B between test1 database on A and test2 database on B.
Then i want to use replication to copy back data from B to A between test2 on B and test1 on A.
please tell me if it is possible. If yes then how.
May 24, 2004 at 9:11 am
I'm also new to replication, but the way I see it, you would use 1 database, Test1 and you would do a merge replication so that the database was on both servers with updates being replicated back and forth between the two.
I am working on a similar situation, but I am having some minor issues with one particularily large database (15GB with one table having 87,034,450 rows). The smaller databases I have setup seem to be working fine.
May 28, 2004 at 7:13 am
You also can use transactional replication so that the changes will replicate back.
But you shoud be carefull to specify the loopback_detection to true in all your articles, so that the replication won't enter in an infinite loop, bewten both publisher/Subscribers.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply