April 7, 2004 at 8:12 am
From what I've read, SQL2000 shouldn't lock tables during the initial snapshot for transactional replication, I even checked the option :
"Do not lock tables during snapshot generation. All Subscribers must be servers running SQL Server version 7.0 or later."
However, running the initial snapshot last night DID lock tables needed by other processes. Am I missing something, or is Microsoft lying ?
Help ! I can't be limited to running snapshots on the weekend.
April 7, 2004 at 8:19 am
Run sp_helppublication and check the compress_snapshot column to be sure that the option is right.
I also use Do not lock tables during snapshot generation... and it works find for me. Could it be another process locking the tables?
April 7, 2004 at 9:11 am
Just a question, why would you run multiple snapshots when you are running transactional replication? A single snapshot should be all that you need (unless you get some major problem).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply