Home Forums SQL Server 2005 Administering rebuild clustered index in transactional replication RE: rebuild clustered index in transactional replication

  • Hey Steve,

    I am a step ahead of our friend.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 .......