October 26, 2009 at 7:11 am
I need to clean my a big table with alot of records.Probably 8 millions records. What is your suggestion, what should I do not to grow any logs. Thank you
October 26, 2009 at 7:16 am
Remove everything or just a selected number of rows? If everything you can truncate table. If you want to delete almost 90% of the table, move the other 10% to another table, drop this table and rename the new table to the old one.
Others might come with better ideas
-Roy
October 26, 2009 at 9:07 am
If you need to remove selected rows, do it in batches. You can switch to simple mode, delete 1000 or so rows, repeat, and then switch back to full mode. Once you're done, be sure you do a full backup
October 26, 2009 at 9:52 am
If do it like this,my logs will not get full right?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply