Post reply

Not replicating DELETES & locking tables!

  • September 28, 2009 at 9:04 am

    #94013

    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

    #1060443

    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