none
Transaction Replication 2008 and Transaction log size

    Question

  • 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

Answers

All replies