I deleted 202451046 rows(14GB) in a table, which is part of replication, and this caused LDF(log) file to grow from 5 gb to 70gb.
then, log reader was taking for ever to move the transactions from log to distributor
and distributor was waiting ..bottom line Replication is OUT of SYNC.
so, please delete by few numbers, instead of deleting entire big table.
Thanks,
then, log reader was taking for ever to move the transactions from log to distributor
and distributor was waiting ..bottom line Replication is OUT of SYNC.
so, please delete by few numbers, instead of deleting entire big table.
Thanks,
No comments:
Post a Comment