March 16, 2010 at 5:09 am
We want to be able to break down some really big inserts because they keep filling our log file, exapnding it, and consuming all of the disk.
The database is in simple mode.
The multiple inserts are held within a begin/commit transaction.
How can we batch up each of those individual inserts but still retain the ability to roll ALL of them back if required?
thanks
March 16, 2010 at 6:06 am
The usual solution is to use one of the bulk import methods, in minimally-logged mode.
The section of Books Online that deals with this is Importing and Exporting Bulk Data.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
March 18, 2010 at 3:28 am
Many thanks for the reply. Am currently digesting the article!
March 18, 2010 at 3:48 am
Steven Jones-245254 (3/18/2010)
Many thanks for the reply. Am currently digesting the article!
It is a lot simpler in practice than it may first appear. The important thing is to make sure you meet the conditions for minimal logging. Post back if you get stuck on anything.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply