I want to replicate 1 million rows from
table2. I have written a job with a query like this:
delete from table1 OUTPUT *.delete into table2
I am executing this job every hour, but it takes a long time.
Another problem is that my log file size is continuously increasing. How can I fix this?