Primary Filegroup is Full

[Buster49]

I am using DTS to load data into a table from a SPSS file. This has worked for several tables so far with no problem. However now I'm getting the above message. The database is 40 Gb in size, there is 580 Gb free on the disk. There is no restriction to the size of the database and it is set to automatically grow in the properties. We have another database that is 262 Gb and has a primary file only. Anyone got any ideas what's going on and how to resolve it?

 

[DrSql]

Is there enought spcae where log file is located and verify its set to autogrowth or any restrictions.. If either is fine,
try to do a DBCC SHrink and DBCC SHRINKFILES at a down time with. Prior to that get a good backup...

Dr.Sql
Good Luck.

 

[mrdenny]

What the growth rate set to? If you haven't changed it it's still set for 10% which in this case would be 4GB at the next extent. The insert is probably timming out before the 4GB extent can be finished and is givin the error that the database is full.

Change the size of each extent to something more managable like 500 MB. It needs to be small enough that it can finish quickly, but large enough that it doesn't need to extend all that often. I like numbers in the 500-1GB range depending on system speed and drive speed.

You'll need to play with the settings to find a number that works best for you.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[Buster49]

Thanks for your responses, it turns out the mdf file was compressed and SQL Server doesn't like compressed files.