Get ACTIVE_TRANSACTION error in simple recovery mode

  • I have a table "FaktTable" with 2.500.000 columns. The Database is in simple recovery mode.

    I have to update the table with this command:

    begin tran FaktTable

    update FaktTable set idMe = m.idMe

    from FaktTable as f inner join DimTable as m

    on f.idMe = m.idMe_old

    commit tran FaktTable

    go

    after waiting for a moment I'll get the error:

    Error 9002, Severity 17 state 4.

    The transaction log for database 'X' is based on 'ACTIVE_TRANSACTION' full.

    There are no other transactions on the server. What can I do?

  • wolle78 (4/9/2014)


    Error 9002, Severity 17 state 4.

    The transaction log for database 'X' is based on 'ACTIVE_TRANSACTION' full.

    There are no other transactions on the server. What can I do?

    Increase the size of the transaction log.

    😎

  • The Database is in simple recovery mode.

  • wolle78 (4/9/2014)


    The Database is in simple recovery mode.

    The transaction is still logged, everything that happens between begin tran and commit tran must be logged, regardless whether it is an implicit or an explicit transaction.

    😎

  • Yes! The Problem is solved. It seems to be the only way.

    Thank you very much! 🙂

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply