September 28, 2009 at 9:04 am
Hi
I have a table that I'd like to use Transactional Replication, but not replicate delete statements but also not lock table when the snapsot is taken. To do this, I create a publication, then put NONE in the delete command Table Article Properties window. In order to apply this, I need to uncheck the Do Not Lock Tables During Snapshort option. Howeveronce applied, I can then choose the Do Not Lock Tables During Snapshort & apply it.
Now, my question is...will this all work? Do the check boxes speak the truth, or will the snapshot lock the tables? Table is hundreds of millions or rows & gets 8 millions inserts a day, so I really can't lock the table when the snapshot is taken. I don't have a maintenance window.
Thanks in advance
Andy
October 1, 2009 at 7:50 am
It usually does not lock table when doing snapshot. But it will lock table when the Schema is generated. It will use a schema lock. But since this a big table, it will slow down all operation. Try to do it when there is less activity on the server.
-Roy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply