Replication sync_method set to concurrent in SQL Server 2000
Home > IT Answers > SQL Server > Replication sync_method set to concurrent in ...
Db23
230 pts.
0
Q:
Replication sync_method set to concurrent in SQL Server 2000
SQL Server 2000, SQL Server database, SQL Server replication
Hi,

Just wondering what happens to data that are inserted during the time of a snapshot replication generation when the sync_method is set to concurrent, as there are no table locks, are the data insert into the publisher then held in the distribution database and when the snapshot has been completed, the data in the distribution database is replicated to the subscribers?

Thanks.

ASKED: Oct 21 2009  12:24 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46765 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Yes, that is precisely what happens.
Last Answered: Oct 22 2009  1:20 AM GMT by Mrdenny   46765 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0