Transaction Log FULL due to ACTIVE_TRANSACTION error?
Posted on 2014-08-08
I was running a simple TRUNCATE TABLE and INSERT INTO table script for a very large table that has over 100 Million Rows of data. I'm transferring this table data from our PRODUCTION server to our DEVELOPMENT server and during the transfer, 3 hours into the process, I received this ERROR:
(1 row(s) affected)
Msg 9002, Level 17, State 4, Line 2
The transaction log for database 'DB1' is full due to 'ACTIVE_TRANSACTION'.
I think the process completed, but checking into this now.
Can someone please assist me in understanding what this error means and what (if anything) is the issue?