I am assigned to move data from huge tables (around 20 hundred thousand record each) to identical history table. But there were when my query is running log file is over grow and mess-up everything. I tried following:
- For each table been archive, is handled as separate transaction
- Any way for history table I didn’t specify the primary key( can this effect)
- All the transactions were written in a single stored procedure.
Can anyone tell me is there any issue with my work or this is not the way I have to follow?