Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PRIMARY Filegroup is full

Status
Not open for further replies.

kmclane

Technical User
Apr 14, 2004
321
US
I am importing a bunch of data from Access to SQL 2000. I have a table that gives me an error when I try to import it. "Could not allocate space in database "dbname" The PRIMARY Filegroup is Full. I have the db set to autogrow and I have 64 gb of free space on the drive. The only thing I can think might be a problem is this is a USB HD, but I've been importing stuff all day and this is by no means the largest table I've done. Any Suggestions?
Thanks, Ken.

- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg
 
you may want to manually grow your DB to a size sufficient enough to prevent the DB from growing.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck
 
OK, how do you do that?

- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top