Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2006
    Location
    Czech Republic
    Posts
    82

    Unanswered: dump transaction db_name with no_log

    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

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    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.

  3. #3
    Join Date
    Sep 2006
    Location
    Czech Republic
    Posts
    82
    is there a way how in BCP in/out do short transaction?

  4. #4
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    -b batchsize

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •