I'm doing a fairly large transfer of data from one table to another (selecting data from one table into another). The database is using a simple recovery model. I thought this eliminated the transaction log and prevented it from filling.
But I'm getting a transaction log full error.
Is this possibly related to the data transfer not being committed until the end of the huge data transfer?
How do you get large transactions to automatically commit ? I don't care about stepping backwards or backing out of the data transfer.
The error is: The transaction log for database 'ARICASES' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
Where is this column? Which sys database is it referring to?
Start Free Trial
