Transaction Replication 2008 and Transaction log size


  • We have data moved from one data file to another

    This is nearly 900gb in size.We have transactional replication setup with push subscription.

    Now after i moved the data the log file grew as expected because I have used drop existing = on when I moved the data of clustered indexed tables.

    The log reader agent started performing bad and is not delivering the transactions any more and I am not able to shrink the t - log even after 2 full backups.

    The db size is 3.5 tb and log size grew from 100gig to 780.

    sql server enterprise 2008 sp3 on windows server 2008 r2.

    Any help would be appreciated .......

    Monday, November 26, 2012 4:12 PM


  • thanks for all the help. I recovred from my problem by reducing the read batch size to 1 and treshold to 10 and increasing the login and query timeout.

    Tuesday, November 27, 2012 5:30 PM

All replies