Transaction Log is full due to 'ACTIVE_TRANSACTION'

Tahir Khalil 41 Reputation points
2024-03-19T17:27:24.1966667+00:00

Hi

While migrating data from a Sybase SQL server to MS SQL Server uusing SSMA for Sybase v9.4 I found about 40 errors showing:

Errors: The transaction log for database 'MyDatabase' is full due to 'ACTIVE_TRANSACTION'.

In result I believe the migration was incomplete for about 40 tables not reached 100%.

Can someone please suggest - what actions needs to be taken to keep the transaction log intact? Also how the transaction get full while batch size in migration is set to 10000?

I am using Client Side Migration Engine - as I am moving from Sybase on Linux to SQL Server on Linux.

Thanks

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
495 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,896 Reputation points
    2024-03-19T19:24:18.6266667+00:00

    The transaction log for database 'MyDatabase' is full .... Can someone please suggest

    Seems your target database on SQL Server is in full recovery mode and the amount of transaction during migration fills the transaction file.

    Either run frequently log backup to release the transaction log or change the recovery mode of the database to "simple".

    0 comments