'PRIMARY' filegroup is full.

  • Thread starter Thread starter Ed Swartz
  • Start date Start date
E

Ed Swartz

I'm attempting to add a new field (datatype = image) to an existing
table. I get the error message:

'Applications (xxx)' table
- Unable to create index 'PK__Applications__672A3C6C'.
ADO error: Could not allocate space for object 'Applications' in
database 'xxx' because the 'PRIMARY' filegroup is full.
Could not create constraint. See previous errors.
The statement has been terminated.


We just bought an additional 50MB and added it to the transaction log
file. We still get the error message listed above. I was able to
sucecssfully add this field to two other smaller tables in the same
database without any problems.

When altering a table design what resources are used ? Transaction log
file, tempdb ?

I want to know if we need to assign the 50MB to another resource or if
we need to buy more storage space to what resource do we add the new
storage space ?

We're using SQL Server in a shared hosted environment and I'm using
Access connected to the SQL Server to update the table designs.

Ed
 
Back
Top