The transaction log for database [database-name] is full due to 'ACTIVE_TRANSACTION'

Asked Jan 24 '20 at 05:55

Active Jan 24 '20 at 07:36

Viewed 162 times

I'm using Microsoft SQL Sever 2014 and executed a stored procedure having larger data for the insert operation. After 3 hours of execution, I got this error

The transaction log for database [database-name] is full due to ACTIVE_TRANSACTION

Any help will be highly appreciated.

Thank you.

Screenshot attached for the database size details.

edited Jan 24 '20 at 07:36

marc_s

732,580
175
1,330
1,459

asked Jan 24 '20 at 05:55

Bhupati Jagi

hi, can you share more details like size of data and operation? – Vikram Jain Jan 24 '20 at 06:08
"having larger data for the insert operation" this makes no sense to me. But more info can be found here https://stackoverflow.com/questions/17674973/the-transaction-log-for-the-database-is-full – Wesley Nightingale Jan 24 '20 at 06:36
@jainvikram444 - added as per your request. – Bhupati Jagi Jan 24 '20 at 06:36
Have you installed all sql-server updates? https://support.microsoft.com/en-us/help/3095156/fix-error-9002-and-error-3052-when-you-try-to-add-or-back-up-log-file – Serg Jan 24 '20 at 06:40
Does this answer your question? [The transaction log for the database is full](https://stackoverflow.com/questions/17674973/the-transaction-log-for-the-database-is-full) – Wesley Nightingale Jan 24 '20 at 06:40
Thanks team...your reference solved my problem.... – Bhupati Jagi Jan 24 '20 at 07:19

The transaction log for database [database-name] is full due to 'ACTIVE_TRANSACTION'

0 Answers0