August 16, 2010 at 3:10 am
Hello, I was just wondering if anyone has seen this before. Basically a DTS job is trying to run but failed until the MDF/LDF file sizes were manually increased (strange as unrestricted autogrowth is enabled on both files). Also there is plenty of space left on all volumes.
I believe the job is only importing around 10lines from a spreadsheet. Anyone any ideas where/what to look at?
Error Detail Records:
Error: -2147024882 (8007000E); Provider Error: 0 (0)
Error string: Not enough storage is available to complete this operation.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100
August 16, 2010 at 9:24 am
SQL Server is running out of memory. Please check the error log file it will have some information about. Restarting the SQL Server is a work around.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 16, 2010 at 9:56 am
I've just checked the ERRORLOG and around the time of the job running (and failing) there is nothing other that successful logons (which we need to log for auditing purposes) is there somewhere else I should be looking?
August 16, 2010 at 10:11 am
You've clearly put SQL 2008 SP1 in the subject line and posted this in the SQL 2008 forum, but the error message seems to be from a SQL 2000 DTS package.
Could you confirm your version please?
There's a very old bug in SQL 2000 to do with this...
August 17, 2010 at 1:54 am
The SQL version is 2008 but from talking with my developers seemingly these are legacy DTS jobs that were migrated over when we upgraded from 2005->2008 and most likely from 2000->2005 in the past.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply