I have a primary database in
FULL recovery mode which is part of
Always On group. Is there a way to minimally log insert operation under
FULL recovery model?
I have a process that is executed each day and insert few millions of records in a table. While the operations continued the transaction log file size is increased dramatically ( from 1 GB to 40 GB).
As I have read I can used some variations of
INSERT which are not fully logging the operation but I am concern about the effect of switching the recovery model?