filegroup is full "SQLState = 37000, NativeError = 1105"

[ASIM]

hi ,
i m loading huge data like more than 50,00,000 records using BCP utility after ends the process i received the following Error .

SQLState = 37000, NativeError = 1105
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space
for object 'BMIS112003' in database 'MY_DB2' because the 'SECONDRY' filegroup is full.

Although I’ve created new filegroup ('SECONDRY' )in drive D:/ that have 10 GB of free Space , then i create table ('BMIS112003' ) using 'SECONDRY' filegroup.

Primary Filegroup created in C:/ that have 1 GB free space.

and all database setting is set as a default.

any one can help me

[MAK]

How about your Log file? Does it have enought space?

[rmiao]

Did you let file in secondary filegroup auto grow? How big the file is now?