April 9, 2014 at 1:38 am
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?
April 9, 2014 at 1:40 am
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.
😎
April 9, 2014 at 1:42 am
The Database is in simple recovery mode.
April 9, 2014 at 1:50 am
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.
😎
April 9, 2014 at 2:06 am
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