October 13, 2009 at 9:31 am
I am using SQL 2000 and last night a DTS package failed with the below error:
Could not allocate space for object "dbo.table" in database 'tom' because the "Primary" filegroup is full.
When I look at the properties of the database I see the following:
Size: 10018.75 MB
Space Available: 439.00 MB
The log files are set like this:
Data : Initial Size = 5495 Autogrowth by 10%,unrestricted growth
LOG: Initial Size = 4524 Autogrowth by 10%,unrestricted growth
Let me know if anyone knows how to fix this!
Chad
October 13, 2009 at 10:40 am
Is the physical hard drive full ?
You fix it by freeing up space. Either non-SQL files on the drive, or shrinking Log or Data files on that drive. Shrinking is not recommened in general, but better than having an inaccessible database.
What is the DTS package doing ?
October 13, 2009 at 11:05 am
I have 63.8 GB free on the physical drive. I am pulling and converting data from and oracle database into my SQL database.
Chad
October 13, 2009 at 11:09 am
Is there a disk quota in place?
October 13, 2009 at 11:28 am
Anything useful in SQL or Windows error logs ? Any chance the disk was full at the time, but has free space now ?
October 13, 2009 at 11:30 am
Do you know the size estimate of the data that you are trying to move from Oracle into SQL2K?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 13, 2009 at 12:40 pm
perhaps the data plus tempdb is greater than the free space. It can help to set the batch size of imports in DTS.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply