[Musil David]

Hello,

I run script that copy data between tables... it is transaction that dont fit log.

A) It stop during running and ask that I should free log to allow transaction proceed further.

Can dump transaction db_name with no_log help me in that case?
Is there any risk?

B) I kill this script and operation rollsback.

Can dump transaction db_name with no_log help me in to speed rollback to free log for other users???? Are there any risks?

Thanks for info¨¨

David

[pdreyer]

A) No dump tran with no_log won't help if it is one big transaction
I suggest you set 'abort tran on log full' for the database to prevent a hang state.
B) No won't speed up the rollback. Break the transaction into smaller chunks and/or increase the log size.

[Musil David]

is there a way how in BCP in/out do short transaction?

[pdreyer]

-b batchsize