SQL Server Performance

Cannot delete a article in merge replication

Discussion in 'Performance Tuning for SQL Server Replication' started by sqldba.madhu, Oct 17, 2007.

  1. sqldba.madhu New Member

    We have merge replication and we no longer need replication. when we are trying to delete a article the transactional log is being filled up. Can some one help me on this.
  2. ghemant Moderator

    Devide your deletion in smaller chunk,i.e. 100000 rec. in one time; and schedule T-Log backup to keep your T-Log in shape.

Share This Page