What does SQL server do when bulk loading data into a Database in Simple mode.

Can some one tell me what SQL server does when bulk loading data into a database that is in simple mode.

Such as file growth, table space growth etc. what about transactions how are they handled?
Steve SamsonAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Ryan McCauleyConnect With a Mentor Data and Analytics ManagerCommented:
In SIMPLE recovery mode, only enough data is kept in the logs to properly roll back uncommitted transactions or roll forward transactions that committed but haven't been written to the data files yet - it's minimal.

During the bulk load, your table grows as a normal rate, but the log space used is minimal, as it's only enough to hold the currently uncommitted (or committed but unflushed) rows.

When you're bulk-loading data and your database is set to SIMPLE recovery mode, it's not itself wrapped in a transaction, so a failed bulk-load could leave half the data in your database. As I understand it, setting your recovery mode to BULK-LOAD will basically put it in SIMPLE mode, with the added benefit the bulk operations can also be rolled forward and backward as an atomic unit.
0
 
Steve SamsonAuthor Commented:
consise
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.