Hi Experts,
I have a scenario where i want to move 3 million records from one table to another in the same database on the same server, last time i did it it created a huge log., my plan is to change the recovery model from full to simple when i do the copy and change it back to full., my concern is whether that would break my transaction log backups.