October 4, 2002 at 12:07 pm
Hello,
Does anyone have snapshot replication implemented? If so, does this type of replication put a shared lock on the table that does not allow users to update the data while the snapshot is being taken?
Or does this type of replication allow concurrent snapshot processing?
I have seen both locks documented for SQL Server 2000 and don't know which one is correct.
Thank you very much,
Melanie
October 4, 2002 at 12:48 pm
Snapshot and transactional both hold locks when you run the snapshot job. There is an option for transactional to use the concurrent snapshot which does not hold locks, but only works in conjunction with a log reader (which snapshot does not have).
A snapshot consists of scripting out all the tables and indexes, and BCP'ing the data out, then applying to the subscriber(s). If locking is an issue you could put something together that would do the same thing in a way that better suits your environment.
Or you could just go with transactional. Only reason I've had to use snapshot was when I had tables with (not my fault!) no primary key.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply