September 18, 2016 at 8:45 pm
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.
September 19, 2016 at 2:18 am
How did you move the 3 million records?
Check out this white paper:
The Data Loading Performance Guide
If you're worried about transaction logs, you might want to switch to bulk-logged recovery mode instead of simple.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy