Thursday, June 23, 2016

Delete on huge table could break replication

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,

No comments:

Post a Comment

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...