Database Administrator Guide > Database Administrator Guide > Populating Tables > Bulk Copying > Transaction Logging During Bulk and Incremental Copy
Was this helpful?
Transaction Logging During Bulk and Incremental Copy
The bulk copy requires only minimal transaction logging.
Note:  A transaction is still entered into the log file and normal logging occurs for the associated system catalogs.
In contrast, an incremental copy can generate a large number of transaction log records. The incremental copy requires logging for every record transfer and every structural change to the table.
An alternative method to reducing logging is described in Large Data Loads with the SET NOLOGGING Statement.
Last modified date: 11/09/2022