Inserting hundreds or thousands of rows goes much faster if you turn off transaction logging. Logging these insertions makes no sense because, in the event of a failure, you can easily re-create the lost work. The following list contains the steps of a large bulk-load operation:
The existing logs can be used to recover the database in its present state, and you can run the bulk insertion again to recover those rows if they are lost.
You cannot turn off logging for databases that use Extended Parallel Server. However, you can create nonlogging tables (raw permanent or static permanent) in the database.
Either ask the administrator to perform a full or incremental backup or use the onunload utility to make a binary copy of your database only.