Hi I'm trying to insert via SSIS 2005 bulk data into a table within 'my database' I get this error:
[Bulk Insert Task] Error: An error occurred with the following error message: "The transaction log for database 'my database' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases".
I discover that log_reuse_wait_desc = ACTIVE_TRANSACTION
I execute DBCC OPENTRAN No active open transactions. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
I issue the command BACKUP LOG MyDatabase WITH TRUNCATE_ONLY
I then issue the command DBCC SHRINKFILE (MyDatabase_log, 10) WITH NO_INFOMSGS. I can see the file is now 10 MB. There is 63 GB available on the drive, so I don't think it is disk space.
When I execute the task again, I get the same message. Now the log file is 1 GB. Any ideas...
asked Sep 13, 2011 at 02:02 PM in Default
Is the log set to AUTO grow? Check the database properties for this.
Also, If you are trying to insert a large amount of data then increasing the tlog to a reasonable size would be beneficial.
answered Sep 13, 2011 at 06:34 PM
Check database log file properties and set log file auto grow on with reasonable size grow.
answered Sep 13, 2011 at 09:53 PM
You may need to add another log file. Also make sure you still have space on the disk where the log file resides.
answered Sep 14, 2011 at 08:21 AM