September 4, 2014 at 7:14 am
I have a job that runs an ssis package. Its failing with the following error message. The recovery model is set to Simple so I dont understand why Im getting this error:
Description: "The transaction log for database 'Portal' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases"
Any info is appreciated.
September 4, 2014 at 7:21 am
Transaction logging still occurs in Simple mode. If the transaction you are running is larger than your transaction log, you'll get that error. Other things can cause or contribute to it as well - replication and log shipping, for example. If you query sys.databases in the way the error message suggests, you'll get more information.
John
September 4, 2014 at 7:21 am
sounds like the log is not large enough to cope with the longest active transaction 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2014 at 7:46 am
http://www.sqlservercentral.com/articles/Transaction+Logs/72488/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply